Forum Discussion

StuartSmith's avatar
StuartSmith
Icon for Power Participant rankPower Participant
6 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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