Forum Discussion
Empty Table until chart selected.
Is it possible to have a empty table until a chart is selected? I have found previous solutions where a measure is created that work with 1 chart, but I want the user to be able to select any chart and the related data set rows are shown in the table.
Thanks in advance,
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.
5 Replies
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/
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.
Hi StuartSmith
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou
