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

Timo Beemster on 04 Dec 2024 09:32:34

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

Format Legend: determine legend order and adapt legend categories (for instance yes, no in Yes, No or to aggregate very long legend names in shorter and more insightfull names). thanks in advance and keep up the good work! Timo

Miguel Myers's profile image Profile Picture

on 18 Oct 2024 21:25:37

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

We often have columns or measures that we want to be formatted the same in EVERY report tab in EVERY visual the same way. There is no universal method to format a measure in every visual in a report. We have to go into each visual on each report tab and do the exact same field formatting (colors, etc.) in each visual. We would like there to be a Universal option.

And, you know what will come next? :-) No doubt, somebody will want the formatting to be report wide EXCEPT for one single visual somewhere. Is that possible too?

Miguel Myers's profile image Profile Picture

Irene S on 18 Oct 2024 09:45:10

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

And besides colors: a default sorting setting for categorical data would be great. If I have e.g. "very high, high, medium, low, very low" as categories, I need to create an extra table, with these 5 categories as rows and numbers in a second column, then sort the text column by the number column and relate them into my data. Being able to set a manual sorting for the dimension (alongside default colors) would be great.

Miguel Myers's profile image Profile Picture

Irene S on 17 Oct 2024 15:56:33

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

YES PLEASE! Having moved from Tableau to Power BI this is the most annoying missing feature, especially when dealing with a rebranding and therefore new colors! Yes, I can change the theme, and when I have used theme colors before, they will get changed with the color of the same position in the new theme, but this still leave the issue for "non theme" colors and when creating new visuals with the same measure/dimension.

Miguel Myers's profile image Profile Picture

John Nickell on 19 Sep 2024 18:48:52

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

Just ran into this with a donut chart. Would like to conditionally format across multiple report pages using a measure (or column) to ensure that a given attribute is given a consistent color. i.e. Table of Data with Type of data A, B, C. I'd like to easily be able to always have the same colors assigned to these types instead of having to manually select the colors on each visual.

Miguel Myers's profile image Profile Picture

Ian Stuart on 06 Nov 2023 16:20:47

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

I have just discovered that I cannot format the text in the legend . Also if I can format the text to be the colour I want, I don't necessarily need the marker (less is more).Cheers,Ian

Miguel Myers's profile image Profile Picture

Kyle Smith on 01 Aug 2022 09:44:07

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

The lack of this feature seems to be a recurring habit of Microsoft in the Power Platform, I remember working with Power Apps at one point and that suffered the exact same problem. Can we get some QoL features please Microsoft?

Miguel Myers's profile image Profile Picture

Jesse S on 05 Apr 2022 00:44:32

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

This is the kind of the thing that leaves you wondering, in 2022... how this is isn't already a basic-included feature?

Miguel Myers's profile image Profile Picture

on 09 Dec 2021 21:30:46

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

Currently the "based on field" formatting (identified by the button "fx" under "Data Colors") is not available for all the standard visuals (like line chart, area chart, stacked area chart, pie chart, donut chart).
This option (available only for the bar/column chart visuals) disappears if a database field is assigned to "Legend". Consequently the only way to customise the colors is by manually selecting them for each case!

Check the comments under this said to be closed idea:
https://ideas.powerbi.com/ideas/idea/?ideaid=31bbd622-9538-46e8-872a-22da964a2585

Miguel Myers's profile image Profile Picture

on 09 Dec 2021 21:30:46

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

The other thread requesting this feature indicates completed, but there are a number of other comments indicating that the fix isn't applied to all built in visuals. - please vote up this idea to get the other visuals fixed as well.

Merged Idea (1)