Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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.
Proud to be a Super User!
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.
Proud to be a Super User!
This is amazing, thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |