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

Robert Houghton on 05 Jul 2020 23:18:26

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

I cant believe this request is still going. I've just completed a large Power BI project and the lack of decent conditional formatting has held us back massively. In fact, if it weren't for the fact we get access to Power BI via our corporate E5 licence we'd probably have been off to Tableau or Qlik because of this limitation. As a minimum Power BI desperately needs conditional formatting on text and on the totals in tables.

Miguel Myers's profile image Profile Picture

Steven Kienle on 05 Jul 2020 23:16:52

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

I agree this should be available through out Power BI, including:

* available for market place visualization developers to use
* ALL value types, not just numeric

Miguel Myers's profile image Profile Picture

bb on 05 Jul 2020 23:15:39

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

this was in Qlikview version 9!! and is one of the most requested features by clients

Miguel Myers's profile image Profile Picture

JaniL on 05 Jul 2020 23:12:40

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

You should be able to write a proper expression to control the format. In fact you should be able to write an expression behind every single property, just like in SSRS.

Miguel Myers's profile image Profile Picture

B.M. on 05 Jul 2020 23:10:34

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

It would be great to have conditional formatting allow for color formatting based on TRUE/FALSE results.

Miguel Myers's profile image Profile Picture

Gilles Leniau on 05 Jul 2020 23:08:29

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

Voted! I need to assign a color to different sport teams and I have the colors as a data point. Would be ideal if the chart bars, maps bubbles, etc. to reflect those colors.

Miguel Myers's profile image Profile Picture

Fernando on 05 Jul 2020 23:03:07

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

Conditional Color formatting should exist.

Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 22:52:20

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

If the color scheme can be defined in another column that would be perfect e.g. country column pulls its color scheme from country_color_scheme.

Miguel Myers's profile image Profile Picture

Aurilio on 05 Jul 2020 22:51:48

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

Like to see conditional formatting for values in a matrix. ie Negative = Red font and positive = Black.

Miguel Myers's profile image Profile Picture

Scott Stamper on 05 Jul 2020 22:51:25

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

I would like to be able to color code text (e.g. "High" is red, "Medium" is yellow, etc. And it would also be great to be able to do the same for unicode. So if I can make an upward arrow green, a downward arrow red, etc. The point it, I have use cases for having more granular control over a variety of text and other DAX calculated elements. Thanks!

Merged Idea (1)