Skip to main content

Power BI

Under Review

Field Format - Report Wide

Vote (3279) Share
Collin Quiring's profile image

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 (119)
Collin Quiring's profile image Profile Picture

Dawn Peacock on 06 Jul 2020 00:14:27

RE: Field Format - Report Wide

Yes, PLEASE! I am constantly having to change data colors for the same field being used across multiple pages. I'd use a measure to set the color but my boss prefers PieCharts and DonutCharts for a certain analysis and the advanced controls for data colors aren't enabled there.

Collin Quiring's profile image Profile Picture

Blanca on 06 Jul 2020 00:13:37

RE: Field Format - Report Wide

Black format as it was before

Collin Quiring's profile image Profile Picture

Antoine AVIAT on 06 Jul 2020 00:13:12

RE: Field Format - Report Wide

Share that one so it gets more vote... ;)

Collin Quiring's profile image Profile Picture

Madhan on 06 Jul 2020 00:13:10

RE: Field Format - Report Wide

Conditional formatting for line chart is very much required .. please ..

Collin Quiring's profile image Profile Picture

Collin Quiring on 06 Jul 2020 00:12:54

RE: Field Format - Report Wide

Agreed, this is like the Canada example below.

Collin Quiring's profile image Profile Picture

Dan on 06 Jul 2020 00:11:39

RE: Field Format - Report Wide

Similar idea has more votes:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15540297-global-data-colors

Collin Quiring's profile image Profile Picture

Dan on 06 Jul 2020 00:11:39

RE: Field Format - Report Wide

I don't believe they were talking on the template or theme level. More like if country was a dimension, any time Canada would be represented in a bar or line plot, it would be a red bar or line. Mexico would be a green bar or line, etc. Could do it with some DAX and rules if the Data Color property had conditional formatting.

Similar IDEA: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15540297-global-data-colors

Collin Quiring's profile image Profile Picture

Ken Robertson on 06 Jul 2020 00:09:49

RE: Field Format - Report Wide


Filter to show the graphics as they appear to a color blind user?

Collin Quiring's profile image Profile Picture

Tad Borowski on 06 Jul 2020 00:08:57

RE: Field Format - Report Wide

Do Templates and Themes not accomplish what you are looking for?

Collin Quiring's profile image Profile Picture

Tom on 06 Jul 2020 00:04:12

RE: Field Format - Report Wide

Being able to conditionally format all my graphics (shapes) and text for KPI thresholds is critical.
Please add this feature ASAP

Merged Idea (15)