Forum Discussion
Empty Table until chart selected.
Hi StuartSmith
If you want to see all visual in blank before you select any chart, you can build a measure and then drag the measure into the Filters Pane to achieve your goal.
I build three table to have a test.
Table1:
Table2:
Show up Table:
Build a slicer by Show up Table. Then build a measure.
Measure = IF(ISFILTERED('Show Up'[Type]),1,0)Drag the measure into all visuals' Filters Pane, let it show items when the value =1.
Result:
Default:
Select show up:
You can download the pbix file from this link: Empty Table until chart selected.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
StuartSmith ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Hi, I want the table to be empty by default and only show data when a user selects a chart.
StuartSmith , bit tricky. The one one approch which come to my mind is to use isfiltered
if(isfiltered(Table[ABC],[Measure],blank())
need to be done for all measures and also need ad more conditions for other paramters
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/