Skip to main content

Power BI

Needs Votes

Field Format - Report Wide

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

5cc23aac 7f30-4adb-83cf-7c9967b4d4ad 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

1a6897a4 a865-e811-a964-000d3a1bee29 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

e335d126 bd09-4f16-ac78-562cf74eb162 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

7944649d 9760-4729-a3ac-44e42337e9d9 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

6a3edb4a 4968-482c-a908-2dd98377da00 on 06 Jul 2020 00:08:57

RE: Field Format - Report Wide

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