Table to show nothing until value selected on Map

[mwinds]

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... 

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/... 

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!

[johnbasha33]

@mwinds create a flag column and use it in the map. 

[mwinds]

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

[v-yilong-msft]

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]

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?

[v-yilong-msft]

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