Show table only when filter or cross highlighed

[shashankp1]

Hi All,

I have a table in the report page which I want to display only during cross highlight or filter applied via slicer.I can use conditional formatting option for value(show font white when no filter or cross highlight & font black when filter or highlight selected) by using ifcroossfilter or iffilter  DAX but problem is that report page already have page level filter so that condition is always satisfied so unable to use that condition.Report is having 9 slicers & 5 other charts on that perticualr page.

I thought of creating 2 buttions with 2 different tables(one is with data & other is with no data) & then use bookmark but i want to aviod that option as I already have many bookmarks & wanted to aviod that option.

Please do let me know if any better option to achieve this.

Thanks,

Shashank

[Greg_Deckler]

@shashankp1 - Perhaps you could use something like HASONEVALUE or do a COUNTX of ALL of the rows and also do a COUNTX of just the rows in scope. If they are equal, then it is not cross highlighted/filtered through another visual.

[amitchandak]

@shashankp1 , a bookmark can only show and hide. But I doubt you can get by other way.

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive