Skip to main content

Power BI

Needs Votes

Epic idea: Conditioanl formatting parameters displayed in legends and tooltips

Vote (3286) Share
Miguel Myers's profile image

Miguel Myers on 08 Oct 2024 05:00:00

Interpreting visuals without a clear legend to indicate logic behind specific styles can lead to confusion and decision-making errors. An idea to enhance clarity and transparency by ensuring legends and tooltips accurately display colors, patterns, and other visual components influenced by logics, would enable report consumers to easily understand the applied logic and make more effective decisions.

Comments (123)
Miguel Myers's profile image Profile Picture

Fiorenzo Anzil on 04 Nov 2021 08:44:42

RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips

Consistent colors definitions should be applied at measure or field level.

Check: https://ideas.powerbi.com/ideas/idea/?ideaid=890487c2-6bd2-eb11-ba5e-281878bd2252

Miguel Myers's profile image Profile Picture

Fiorenzo Anzil on 04 Nov 2021 08:40:54

RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips

Consistent colors definitions should be applied at measure or field level.

Check: https://ideas.powerbi.com/ideas/idea/?ideaid=890487c2-6bd2-eb11-ba5e-281878bd2252

Miguel Myers's profile image Profile Picture

Craig Howard on 13 Sep 2021 19:53:42

RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips

Have been waiting for something to solve this since starting using PBI. Exactly as the poster described - per-customer colours on all visuals and shared between reports

Miguel Myers's profile image Profile Picture

Upwork Developer on 05 Aug 2021 20:48:35

RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips

It's very important to have data color conditional formatting in charts with a legend (line charts, bar/column charts, scatter chart, pie chart). Color is one of the most important attributes in data visualization and currently we can't really control data colors when we need (for example when we have multiple lines on a line chart). Proper use of data colors currently is possible only using workarounds (caclualtion groups, overlays of transparent visuals).

Miguel Myers's profile image Profile Picture

Angela Antholz on 22 Jun 2021 15:40:43

RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips

This would be so helpful. Having to format individually is back to Excel which we are trying to get away from.

Miguel Myers's profile image Profile Picture

Brad Lynch on 04 May 2021 19:35:55

RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips

Yes please. This would be a timesaver. Hopefully for the Report Server version too!

Thank you!

Miguel Myers's profile image Profile Picture

Karen Monken on 03 Mar 2021 15:45:16

RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips

Yes, this would be so helpful! I had the exact situation as the Canada example. It will try to color code based on how they are sorted in the chart, so if you have multiple charts showing different sets of data, but Canada is the highest in one and the lowest in the other, it will be a totally different color. Hard to track the same country across the different visuals.

Miguel Myers's profile image Profile Picture

Gary Thomann on 18 Feb 2021 01:18:06

RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips

#,#;[Red](#,#);"-" add colour to custom format

Miguel Myers's profile image Profile Picture

C L on 20 Oct 2020 21:58:21

RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips

Very needed!

Miguel Myers's profile image Profile Picture

Alex on 10 Jul 2020 17:21:38

RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips

'Perhaps similar to this request. But to clarify looking for the same measure across different charts and different pages to maintain :

1. Consistent Data Colors - If color is changed on one chart, change is applied across all charts in the same file

2. New Chart - If new chart is created in same file and metric with previously defined color is added to new chart, previously assigned color would be "auto-assigned" instead of default color

3. If 1 and 2 are not possible based on some other restriction the ability to import metric specific color scheme via lookup table that would drive this


Nice to have:
- Less clicks to get to HEXCODE editor
- Options for different color selector ie. wheel, square, circle, etc..
- Changing color in right click menu on legend or graph part

Merged Idea (1)