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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
Solution Sage
Solution Sage

@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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.