Skip to main content
Microsoft Idea

Power BI

Under Review

Field Format - Report Wide

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

Juerg H. on 05 Jul 2020 22:33:16

RE: Field Format - Report Wide

Like we can do with filters we should be able to define data colors not only on the level of a single visual but also on higher levels which are a reports page and even the entire report.

Collin Quiring's profile image Profile Picture

plaidDK on 05 Jul 2020 22:32:36

RE: Field Format - Report Wide

We need this badly - An opportunity to conditional format nonmeasures /additives . There is no possibility to conditional format like if then else.

Hopefully you will pay attention to this!

Collin Quiring's profile image Profile Picture

Mike on 05 Jul 2020 22:28:49

RE: Field Format - Report Wide

There are other registered ideas that are almost the same as this one. This uncontrolled idea submitting option is not efficient. I think this is a really important feature but because of the inefficient registration does not get the votes it deserves (now its fragmented).

Not my text but I agree fully:
I think that Microsoft must spend more time on these basic, fundamentals of reporting / dashboarding. I worry that too often they spend more time chasing cool, "glitzy" functionality, at the expense of the core functionality that other products have

Collin Quiring's profile image Profile Picture

Scott Stamper on 05 Jul 2020 22:26:36

RE: Field Format - Report Wide

There are a variety of Text based and other conditional formatting upgrade requests. Any chance you can combine those into one? My primary focus is on conditional formatting for text. So if the field returns "Yes", color it green. Thanks, Scott

Collin Quiring's profile image Profile Picture

Berkley on 05 Jul 2020 22:22:40

RE: Field Format - Report Wide

Please add true conditional formatting. A developer should be able to base the lower/upper bounds on either a field value or a dax statement. (Ex. if(x>=y,z,a)

Collin Quiring's profile image Profile Picture

Joe Williams on 05 Jul 2020 22:13:58

RE: Field Format - Report Wide

The usage here is necessary. I often use the card in the upper right hand corner to show high level KPIs, which is usually a +/- variance. Green = good, red = bad.

Collin Quiring's profile image Profile Picture

Ross ross.palmer on 05 Jul 2020 22:08:33

RE: Field Format - Report Wide

Need this sort of functionality ASAP!

Collin Quiring's profile image Profile Picture

Power BI User on 05 Jul 2020 22:06:46

RE: Field Format - Report Wide

I don't understand why this has so few votes. Perhaps there's another similar entry? Anyway, the best way to achieve this, IMHO, is to embrace web standards. Let me build my own visualization components using SVG and CSS.

Merged Idea (15)