Forum Discussion
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
- AnonymousNot 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.
- mwindsHelper 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?
- AnonymousNot 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
- johnbasha33Super User
mwinds create a flag column and use it in the map.
- mwindsHelper I
Hey, do you have a guide online for what you mean please?