Skip to main content
Microsoft Idea

Power BI

Under Review

Field Format - Report Wide

Vote (3100) 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

Gilles Leniau on 05 Jul 2020 23:08:29

RE: Field Format - Report Wide

Voted! I need to assign a color to different sport teams and I have the colors as a data point. Would be ideal if the chart bars, maps bubbles, etc. to reflect those colors.

Collin Quiring's profile image Profile Picture

Fernando on 05 Jul 2020 23:03:07

RE: Field Format - Report Wide

Conditional Color formatting should exist.

Collin Quiring's profile image Profile Picture

Power BI User on 05 Jul 2020 22:52:20

RE: Field Format - Report Wide

If the color scheme can be defined in another column that would be perfect e.g. country column pulls its color scheme from country_color_scheme.

Collin Quiring's profile image Profile Picture

Aurilio on 05 Jul 2020 22:51:48

RE: Field Format - Report Wide

Like to see conditional formatting for values in a matrix. ie Negative = Red font and positive = Black.

Collin Quiring's profile image Profile Picture

Scott Stamper on 05 Jul 2020 22:51:25

RE: Field Format - Report Wide

I would like to be able to color code text (e.g. "High" is red, "Medium" is yellow, etc. And it would also be great to be able to do the same for unicode. So if I can make an upward arrow green, a downward arrow red, etc. The point it, I have use cases for having more granular control over a variety of text and other DAX calculated elements. Thanks!

Collin Quiring's profile image Profile Picture

Julie Turner on 05 Jul 2020 22:50:57

RE: Field Format - Report Wide

Conditional formatting should not only be available if you summarize your data... if you want a line to turn red based on a value in your table why would you force the user to summarize????

Collin Quiring's profile image Profile Picture

Power BI User on 05 Jul 2020 22:50:35

RE: Field Format - Report Wide

Please add the ability to conditionally format text independent of background. It would make a huge difference for financial reporting and allow the correct emphasis to be placed on columns or outliers.

Collin Quiring's profile image Profile Picture

Power BI User on 05 Jul 2020 22:49:16

RE: Field Format - Report Wide

yes, that would be great.

Collin Quiring's profile image Profile Picture

RD on 05 Jul 2020 22:48:01

RE: Field Format - Report Wide

Yes, This would be nice, E.g Based on a measure value we should be able to conditional format the text with in the dashboard

Collin Quiring's profile image Profile Picture

Kevin Fawcett on 05 Jul 2020 22:47:54

RE: Field Format - Report Wide

Really really would like to see conditional formatting for values in a matrix. ie Negative = Red font and positive = Black. Please add!!

Merged Idea (15)