Power BI On Off switch wth the new slicer buttons

The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. accessanalytic...
Did you know I've written a book "Power BI for the Excel Analyst"?
pbi.guide/book/
Connect with me
wyn.bio.link/

[@larrygilbert7273]

Very cool. Of course, for the text button, you could always created your own "On" and "Off" images to use, that have the actual text.

[@AccessAnalytic]

Yep 😀

[@PowerBIPark]

Awesome stuff Wyn!

[@AccessAnalytic]

Cheers Injae!

[@Lou_1111]

Nice Cool! 🤩 Will try very soon! Thank you

[@AccessAnalytic]

Great

[@SolidSnake59]

Great example. Thanks!

[@AccessAnalytic]

You’re welcome

[@teaking1981]

I ran into this recently when filtering measures in a combo chart, to show different measures based on selection, and noticed the same issue with the legend I had, it still shows all measures even if it returns blank, has anyone found a solution to this? And I would like to say the method in this video is more elegant, and easy to use. Always like seeing these videos and getting new ideas.

[@AccessAnalytic]

Thanks, the measures somehow don't recognise filtering from within the visuals. I don't know of a fix.

[@teaking1981]

@@AccessAnalytic thanks, appreciate the response.

[@EricPeabody]

Are you going to do a video on those custom labels for the line? You were switching quickly but it looked the labels were only showing where the trend changed slope and they had some colored icons as well.

[@AccessAnalytic]

Hi Eric, yes I'll probalbly do one showing those icons (just an IF [Variance] > 0, "⬆","🔻") and also a similar thing in the new Card Visual reference labels.

[@muhammetmuslu4429]

realy cool. ı tried it

[@AccessAnalytic]

Great!

[@findthetruth3021]

Hi, I have a very difficult question and I searched through the Google and chatgpt and everywhere but couldn't find a solution for that. I have an idea to combine two different maps one is going to be in shape file and the other one is going to be point map. So my idea is to make the background of the point map transparent and only leave the points by latitude and longitude so that I can make a group of points by latitude and longitud with the shaple file map and putting the points by latitude and longitud over the shape file. Finally, make them on group which will appear like that I have both shaple file plus points by latitude and longitud together. But until now I couldn't find a solution how to remove or make the point map background transparent or without having any colour except the points by latitude and longitud. Please help me in this regard. Thanks in advance.

[@AccessAnalytic]

I don’t know sorry I’d suggest asking at community.powerbi.com/t5/Desktop/bd-p/power-bi-designer

[@SergiyVakshul]

Why don’t just put "Button selected" measure to a Label field well of the slicer and get rid of a card?

[@AccessAnalytic]

I couldn’t get the label to change on selection. Can you explain how to do it ?

[@SergiyVakshul]

@@AccessAnalytic You are right - apparently, there is no way to update on selection. I had a look on "All Queries" to the engine in DAX Studio and saw that the slicer sent no queries when I selected/deselected slicer buttons. Changing the image in Fill subsection of Button section is the only option.

[@AccessAnalytic]

It appears to be a similar issue that you can’t add a dynamic heading to a chart (e.g. to add a Title with the name of the month selected when clicking on the March column )