Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Epic idea: Conditioanl formatting parameters displayed in legends and tooltips

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.

Status: Needs Votes
Comments
bhaskarpf
New Member
this was in Qlikview version 9!! and is one of the most requested features by clients
Steven_Kienle
New Member
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
rhoughton
New Member
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.
david_southerla
New Member
I don't even need to be able to set the colors, I just want visualizations on one dashboard to use the same color for the same value in a common field.
KRIS_WILLISON_K
New Member
I was most disappointed yesterday to find that I could only use conditional formatting on a field that has had an aggregate function applied. I could use AVERAGE in the one column I need, but then I end up with decimal places I don't want to see. Either need 1) conditional formatting similar to EXCEL 2) ability to specify the output format for numbers in a table 3) ability to turn off totals line for a given field in a table
xpouradier1
New Member
The current possibilities of formatting in Power BI are too basic. Why can I not color a whole line of my table regarding the text of a certain column in 2018 ? (a matrix that I cannot rotate by the way)
joostoosterbaan
New Member
This is a feature i would also like very much
brad_rose
New Member
I think this is a good idea and will be helpful
stanley_zielins
New Member
Yes, this would be helpful.
a_smallworld
New Member
This is pretty easy to conditional format text if your using IMPORT or SQL, this doesn't work on DIRECT connections. First create additional NEW COLUMN in your table The following query will populate the NEW COLUMN based on the test string you defined, in the example ive used planet names StatusColour = If('table'[table.value]="mars",0) & if('table''[table.value]="sun",1) & if('table'[table.value]="earth",2) You can then apply conditional formatting to your TEXT column either background colour or font colour or both (example below) Based on Field = NEW COLUMN (SUM) IF value is 0 then IF value is 1 then IF value is 2 then shame about pie charts, hope that comes soon!