how to load only headers on table visual at first

[NISHA_S]

Hi,

        i have  a report with a slicer and a table visual in report.I need only headers to load firstly and values should be based on the users selection on slicers.Is it possible?

 

[Anonymous · Accepted solution]

Hi @NISHA_S ,
Yes it is possible. First, you need to create a measure based on slicer selection.

show blank first = CALCULATE ( IF ( ISFILTERED ( TableName[collumn] ), 1, 0 ), ALLSELECTED ( TableName) )

Then in the filter pane for the table visual set it to 1.

Regards,

Ashfiya

--------------------------------------------------------------------------------------------------------------------------

Did I help you today? Please mark my post as a solution and hit the Kudos button.