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")
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!