Forum Discussion
Power BI show and hide visuals based on selection
Hello everyone,
I'm new to Power BI and I would like some help with my report.
I have a :
-Slicer (let's call it products)
-a Table (Themes) that changes when Product Slicer selected
-a Table (Comments) that appears when the Theme Table is selected (a Message "Click on Themes to see the comments" covers it).
I have so far managed to do this. I've created measures:
Check Filtered = ISFILTERED(Product Slicer)
Hide visual = IF([Check Filtered],1,0)
Message = IF([Check Filtered],"","Click on Themes to see the comments")
and another measure Make transparent = IF([Check Filtered],"#FFFFFF00","White")
and another measure Make transparent = IF([Check Filtered],"#FFFFFF00","White")
while following this vidéo: https://www.youtube.com/watch?v=ys-SBf_-Lxk&t=2s
What I'm struggling to do is that when I select the final table (Comments Table), after Product Slicer and Theme is selected and click on a specific comment to see more details, the Comments table dissapears.
Can you please help me with that? I can share more info or a demo if needed.
Thank you so much!
Can you please help me with that? I can share more info or a demo if needed.
Thank you so much!
1 Reply
- Fowmy
Super User
Anonymous
Can you sahre a demo file the expected results?
