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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Domenick
Helper IV
Helper IV

Using map to show/filter relevant data in nearby visuals (leveraging the highlight feature)

Hi all,

 

I want to leverage PowerBI's highlight feature to create a report so that clicking a point on a map will filter visuals to the right of the map. This is obviously a default feature ("highlight"), however, I'm not sure what to display when nothing is selected. Certain visuals make sense as an aggregate but others (like text fields) do not. So for those, it would be best to either show nothing or show something like "Select a location." Any ideas?

1 ACCEPTED SOLUTION
DataInsights
Super User
Super User

@Domenick,

 

You could try a measure like this:

 

Example Measure =
IF (
    ISCROSSFILTERED ( DimTable[Location] ),
    <Your measure>,
    "Select a location"
)

 

When nothing is selected on the map (i.e. no location has been clicked), the measure will return the text "Select a location". Otherwise, it will return the measure you want to display.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
DataInsights
Super User
Super User

@Domenick,

 

You could try a measure like this:

 

Example Measure =
IF (
    ISCROSSFILTERED ( DimTable[Location] ),
    <Your measure>,
    "Select a location"
)

 

When nothing is selected on the map (i.e. no location has been clicked), the measure will return the text "Select a location". Otherwise, it will return the measure you want to display.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




This is amazing, thank you!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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