Skip to main content

Power BI

New

Power BI Interaction Highlighting. Option to hide other unselected Value labels instead of simply dimming them

Vote (1) Share
Jordan Williams's profile image

Jordan Williams on 07 Nov 2024 17:07:42

I wish I could attach this pic I made... once you see it, it makes so much sense. Interactions lets you either filter multiple charts to the value based on something you click or highlight the selected item on all visuals while dimming the other selections.


A user requested a way to highlight but blind the names of the other selections instead of simply dimming or filtering them out. That way the bars or table values are still present in other visuals but the other names of things are suppressed.


Example:


Acme Co. ----------- 34%

Widget Inc. --------------------- 50%

Things Corp. ------ 25%


If I pick Acme Co. it shows


----------- 34%

Widget Inc. --------------------- 50%

------ 25%


So then you still have your frame of reference yet blind the competing choices.


A filter would just show

Widget Inc. --------------------- 50%


And highlight shows

Acme Co. ----------- 34%

Widget Inc. --------------------- 50%

Things Corp. ------ 25%


But a filter/highlight choice would be sort of a combination of the 2 ideas.


Comments (2)
Jordan Williams's profile image Profile Picture

Kieran Leigh on 08 Nov 2024 10:07:18

RE: Power BI Interaction Highlighting. Option to hide other unselected Value labels instead of simply dimming them

I think there is a better way to approach this: add a "State" option in the visual format pane with options "Normal", "Highlighted" and "Dimmed". Add a transparency option to the formats. This would let you customise the dimmed values to have 100% transparent labels, but would also allow many other customisations of how cross-highlighting is formatted.

Jordan Williams's profile image Profile Picture

Jordan Williams on 07 Nov 2024 17:12:08

RE: Power BI Interaction Highlighting. Option to hide other unselected Value labels instead of simply dimming them

Example:Acme Co. ----------- 34%Widget Inc. --------------------- 50%Things Corp. ------ 25%IDEA: If I pick Widget Inc. it now looks like this and highlights the selection but hides the other names of things.................. ----------- 34%Widget Inc. --------------------- 50%.................. ------ 25%So then you still have your frame of reference yet blind the competing choices.A filter just does this and looks uninformativeWidget Inc. --------------------- 50%And highlight showsAcme Co. ----------- 34%Widget Inc. --------------------- 50%Things Corp. ------ 25%