Forum Discussion
Hide Visual based on Selection
Hi,
I have a PIE CHART which contains 2 measures as its values:
CountGood = CALCULATE(COUNT(ObjectsTbl[Obj_Id]), FILTER(ALL(ObjectsTbl), ObjectsTbl[Obj_Type] = SELECTEDVALUE('ObjectsTbl'[Obj_Type]) && ObjectsTbl[objState] = "Good" ))CountBad= CALCULATE(COUNT(ObjectsTbl[Obj_Id]), FILTER(ALL(ObjectsTbl), ObjectsTbl[Obj_Type] = SELECTEDVALUE('ObjectsTbl'[Obj_Type]) && ObjectsTbl[objState] = "Bad" ))
I want to hide this visual when an item from a table of all objects are listed is selected,
So I tried to create another measure like this:
ShowChart = IF(ISFILTERED(ObjectsTbl[Obj_Id]), 1, 0)
But when I try to add this to the Visual's Filters, it doesn't let me choose a condition.
What am I doing wrong? How can I Hide this visual?
Regards,
K
Hello,
You can't hide a visualization through dax. you can use bookmarks to hide / show visuals.
Check this article to see how to hide / show visuals using bookmarks https://www.aerieconsulting.com/blog/how-to-hide-and-show-visuals-in-power-bi
If I answered your question, please mark my post as solution, Appreciate your Kudos👍
1 Reply
Hello,
You can't hide a visualization through dax. you can use bookmarks to hide / show visuals.
Check this article to see how to hide / show visuals using bookmarks https://www.aerieconsulting.com/blog/how-to-hide-and-show-visuals-in-power-bi
If I answered your question, please mark my post as solution, Appreciate your Kudos👍