Power BI
Needs VotesEpic idea: Conditioanl formatting parameters displayed in legends and tooltips
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)
- Merged Idea (1)
RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips
Adding conditional formatting to the background of a report would be extremely beneficial as well. We are attempting to create a dashboard that is displayed on SharePoint Online where the 'heat' boxes would have made the live dash much more dynamic.
RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips
I agree.. this helps in elevating conditional formatting abilities for power bi.
RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips
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!
RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips
I have a clustered column chart showing sales for this year vs. equivalent period last year.
I'l like to be able to highlight the current month this year in a different colour.
We basically need the conditional format by formula ability we have in Excel.
RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips
Yes, this would be helpful.
RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips
I think this is a good idea and will be helpful
RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips
This is a feature i would also like very much
RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips
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)
RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips
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.
RE: Epic idea: Conditioanl formatting parameters displayed in legends and tooltips
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