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

Damian Fears on 05 Jul 2020 23:50:25

RE: Field Format - Report Wide

Conditional Formatting of field names would be awesome - then I could make my reports / charts really multi-lingual.

Collin Quiring's profile image Profile Picture

Daniela on 05 Jul 2020 23:49:22

RE: Field Format - Report Wide

I think we need the Conditional Format in all the visual objects, this would open the doors to many opportunities of personalization of our reports

Collin Quiring's profile image Profile Picture

Chris Tourville on 05 Jul 2020 23:48:45

RE: Field Format - Report Wide

Agreed - nothing more unprofessional than having two charts with completely different color schemes for the same field. AT LEAST make sure they are consistent, but beyond that let us pick our own as well.

Collin Quiring's profile image Profile Picture

Craig on 05 Jul 2020 23:48:05

RE: Field Format - Report Wide

Same here. My team are developing multiple reports using some common dimensions. Would like to be able to lock in the colour for each dimension value so that visuals maintain consistent styling across all the reports -- e.g. the pie slice for "apple" is always red, or the chart line for "Banana" is always yellow, etc. We were hoping the colours could be defined via our custom JSON theme or in the dimensional table somehow.

Collin Quiring's profile image Profile Picture

Aaron Lynch on 05 Jul 2020 23:47:21

RE: Field Format - Report Wide

Really need this for dates. Greater than or less than Today () specifically...

Collin Quiring's profile image Profile Picture

Power BI User on 05 Jul 2020 23:47:03

RE: Field Format - Report Wide

This is a must for dates. Particularly relatively (i.e. within the last month)

Collin Quiring's profile image Profile Picture

Lauren Jatana Vathje on 05 Jul 2020 23:41:29

RE: Field Format - Report Wide

The ONLY thing holding me back from making my monthly report super valuable and professional looking is this color issue. (e.g. this department should be able to quickly look at the report and know - my stats are purple... how is purple doing this month?... because the rest is just nice to know for them)...

Collin Quiring's profile image Profile Picture

Lauren van Rensburg on 05 Jul 2020 23:37:24

RE: Field Format - Report Wide

Conditional Formatting is vital across all visuals please.

Collin Quiring's profile image Profile Picture

Jose Garcia on 05 Jul 2020 23:36:18

RE: Field Format - Report Wide

Would be great to add same conditional formatting capabilities as in SSRS

Collin Quiring's profile image Profile Picture

Mark Read on 05 Jul 2020 23:35:23

RE: Field Format - Report Wide

This is critical in many matrices and graphics

Merged Idea (15)