Forum Discussion

mwinds's avatar
mwinds
Helper 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.

 

I've read a few solutions but they're not working for me and i have no idea why.

Firstly i created a measure as described here: https://community.fabric.microsoft.com/t5/Desktop/Empty-table-visual-when-nothing-is-selected-on-Map-Visual/m-p/670714/highlight/true#M322754 

 

Here is my measure and the map when nothing is selected:

The Card for "filter 1" us 2 as expected. But the table is still listing out all of the rows. Not as expected.

When a value is selected, the card for filter 1 is 1, and the table only shows that row, as expected. 

 

Solution 2 which i have tried comes from: https://community.fabric.microsoft.com/t5/Desktop/Filtering-a-Demension-Filter/m-p/601883/highlight/true#M286404 

 

This follows a similar technique. 

If a value is selected on the map, the building name is shown in the filter 2 card. 

But as you can see when nothing is selected and the filter 2 card is blank. But all of the rows are being shown.

 

Can someone help? To me it doesn't make sense why they're all being shown.

Thanks!

 

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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
      Helper I

      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

        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

    • mwinds's avatar
      mwinds
      Helper I

      Hey, do you have a guide online for what you mean please?