Forum Discussion

mwinds's avatar
mwinds
Icon for Helper I rankHelper I
2 years ago

Table to show nothing until value selected on Map

Hi all,   I have created a map using Lat and Lng coordinates. I'd like a table to show nothing unless a point (bubble) has been selected. That table shows all the data for that point selected.   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi mwinds ,

Based on your problems, here are my answers. I think you may ask how can you get filter to make the view show blank styles without any state selected instead of showing the view with all content?

I think you can use this measure and here is the DAX code.

 

SlicerCheck =
IF (
    CALCULATE ( DISTINCTCOUNT ( [SlicerColumn] ), ALLSELECTED ( [SlicerColumn] ) ) = 1,
    "Y",
    "N"
)

I think this topic may help you: Solved: Visualisations blank until something selected in a... - Microsoft Fabric Community

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • mwinds's avatar
    mwinds
    Icon for Helper I rankHelper I
    2 years ago

    Hi Yilong, 

     

    Thanks for your reply.

    No luck unforunately. It's behaving the same way as the other measure i created.

    I wonder if I'm using the wrong column choice? At the moment, I'm choosing name of the building, which is in my table and the map. Should i be using a different column?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi mwinds ，

      Could you please give me your .pbix file? I think there may have been some internal issues that caused your problem to arise.

       

       

      Best Regards

      Yilong Zhou