Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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!
Hey, do you have a guide online for what you mean please?
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.
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?
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
User | Count |
---|---|
94 | |
92 | |
84 | |
83 | |
49 |
User | Count |
---|---|
150 | |
146 | |
112 | |
73 | |
56 |