Skip to main content

Power BI

Needs Votes

Epic idea: Conditioanl formatting parameters displayed in legends and tooltips

Vote (3225) 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 (122)
Miguel Myers's profile image Profile Picture

James Yates on 06 Jul 2020 00:16:28

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

I concur! Manually creating category/color uniformity across reports for my users is time consuming. I wish weekly, sometimes daily, that this feature existed.

Miguel Myers's profile image Profile Picture

Dan Robbins on 06 Jul 2020 00:14:37

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

Wouldn't it make sense to have a Color Values box on the 'fields' view that you could drop a column into to set color values instead of having to go into the format view?

When you have a multi-page report with 4 to 7 Line and stacked column charts per page, it takes significant time to update all of them.

Miguel Myers's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:14:36

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

Please make this an option - it's so fiddly and time consuming have to go to each individual visualisation and then select the data colours!

Miguel Myers's profile image Profile Picture

Dawn Peacock on 06 Jul 2020 00:14:27

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

Yes, PLEASE! I am constantly having to change data colors for the same field being used across multiple pages. I'd use a measure to set the color but my boss prefers PieCharts and DonutCharts for a certain analysis and the advanced controls for data colors aren't enabled there.

Miguel Myers's profile image Profile Picture

Blanca on 06 Jul 2020 00:13:37

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

Black format as it was before

Miguel Myers's profile image Profile Picture

Antoine AVIAT on 06 Jul 2020 00:13:12

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

Share that one so it gets more vote... ;)

Miguel Myers's profile image Profile Picture

Madhan on 06 Jul 2020 00:13:10

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

Conditional formatting for line chart is very much required .. please ..

Miguel Myers's profile image Profile Picture

Collin Quiring on 06 Jul 2020 00:12:54

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

Agreed, this is like the Canada example below.

Miguel Myers's profile image Profile Picture

Dan on 06 Jul 2020 00:11:39

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

Similar idea has more votes:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15540297-global-data-colors

Miguel Myers's profile image Profile Picture

Dan on 06 Jul 2020 00:11:39

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

I don't believe they were talking on the template or theme level. More like if country was a dimension, any time Canada would be represented in a bar or line plot, it would be a red bar or line. Mexico would be a green bar or line, etc. Could do it with some DAX and rules if the Data Color property had conditional formatting.

Similar IDEA: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15540297-global-data-colors

Merged Idea (1)