Collin Quiring on 22 Oct 2019 03:40:22
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?
- Comments (118)
- Merged Idea (15)
RE: Field Format - Report Wide
Conditional formatting desperately needs to be updated. I can't believe I can do so many powerful things with this product, but easily coloring text red if the date is older than X years (for example) isn't one of them. It is extremely frustrating.
RE: Field Format - Report Wide
Additionally conditional formatting across rows instead of columns needs to be incorporated.
RE: Field Format - Report Wide
This is a must. The data bars in matrix/tables need more color options (such as based on defined value ranges) 0-6 RED, 7-8 AMBER, >9 GREEN
RE: Field Format - Report Wide
I desperately need to be able to conditionally format the segments of a pie chart
RE: Field Format - Report Wide
Conditional color formatting on PIE/Donut charts would be extremely beneficial. Color banding depending on fill value. eg,
>80% = Green
>60% = Yellow
RE: Field Format - Report Wide
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: Field Format - Report Wide
I agree.. this helps in elevating conditional formatting abilities for power bi.
RE: Field Format - Report Wide
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: Field Format - Report Wide
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: Field Format - Report Wide
Yes, this would be helpful.