Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
mwinds
Helper I
Helper I

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

 

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

mwinds_0-1712226672834.png

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

 

mwinds_1-1712226933724.png

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 5
johnbasha33
Super User
Super User

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

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

v-yilong-msft
Community Support
Community Support

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.

mwinds_0-1712307952816.png

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.