Reggie Jardin Comendador on 27 Jul 2023 11:32:38
Dear Microsoft Power BI Team,
I'd like to suggest a feature for Power BI that would enhance its interactivity and user experience. It would be great if we could have an option to dynamically color Card visuals based on selections made in Slicers.
Specifically, I envision a functionality where selecting an item in a slicer highlights or changes the color of a corresponding Card visual. When the item is deselected in the slicer, the Card visual would then return to its default color. This would provide an immediate, visual indicator of the slicer selection, which could greatly enhance the understanding and readability of our dashboards.
Having this functionality would be particularly useful in scenarios where multiple Cards are present on the dashboard, and we want to direct the viewer's attention to specific Cards based on slicer selections.
Thank you for considering this suggestion. I believe this feature would greatly benefit all users and help create more interactive, dynamic, and user-friendly reports.
Best regards,
Reggie Jardin Comendador
- Comments (1)
RE: Suggestion: Dynamic Coloring of Card Visuals Based on Slicer Selections
I think this should be possible using the facilities in the new card visual, although it would take one measure per card. You can set a fill that takes a field value. This would be a measure that returns a CSS3 colour value:Apply conditional table formatting in Power BI - Power BI | Microsoft Learn (Although this is for tables, the same concept should apply)You could then write a measure something like...var sv = SELECTEDVALUE('slicer table'[your slicer field],"--")
RETURN
if(sv="potatoes","red","white")
(Note I haven't tested this, but it should demonstrate the concept.).