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

on 09 Dec 2021 21:29:56

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

It’s good that you added it, but it’s really some basic alpha-beta level only, in my opinion. It should enable the users to conditionally-format also the dimensions (Attributes) and not only measures (Metrics).

For example I have got a report with Revenue $ by region (AMER / EMEA / APJ) and i want the colors of the whole row / column / field to be cahnged based on the Region dimension OR Revenue measure).
Today, we can do only set up a simple conditions to measures.

Miguel Myers's profile image Profile Picture

on 09 Dec 2021 21:29:56

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

It would be great if you could do conditional formatting throughout all of Power BI Desktop. e.g. text boxes have conditional formatting based on your data. It would be great if conditional formatting also worked with the different bars in bar charts etc.

Miguel Myers's profile image Profile Picture

on 09 Dec 2021 21:29:56

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

I would like the option to set global data colors for my reports based on a specific field within the data, that will impact all charts using that field.

For example, in our current data set we have a field 'Customer'. Each customer is assigned their own unique color that corresponds to our other documentation, to make charts easier to interpret.

Currently, I have to set the 'data colors' options for every single chart that uses the 'Customer' field. Whenever a new customer appears in our data set, I have to modify the data colors for multiple charts individually.

I would like the option to be able to set data colors for this field on a report-level basis.

Miguel Myers's profile image Profile Picture

Fiorenzo Anzil on 04 Nov 2021 09:31:50

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

Fully agree! This is essential. The same idea has already been presented:
Conditional Formatting throughout (829 votes)
https://ideas.powerbi.com/ideas/idea/?ideaid=59734f89-363d-41e8-be27-f123765dfd2f
Field Format - Report Wide (798 votes)
https://ideas.powerbi.com/ideas/idea/?ideaid=a24b6ebf-14a5-4134-b6ae-a765b407b007
Set data colors programmatically in power desktop (40 votes)
https://ideas.powerbi.com/ideas/idea/?ideaid=a7b30bd6-7827-4311-9ff1-d5746e50f10b

Miguel Myers's profile image Profile Picture

Fiorenzo Anzil on 04 Nov 2021 08:56:19

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:50:54

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

I agree. This should be implemented also for other standard chart. Check my idea: https://ideas.powerbi.com/ideas/idea/?ideaid=37290899-b035-ec11-b76a-281878bdb01d

Miguel Myers's profile image Profile Picture

Fiorenzo Anzil on 04 Nov 2021 08:50:09

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:48:36

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:47:29

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:45:11

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

Merged Idea (1)