Skip to main content

Power BI

Under Review

Field Format - Report Wide

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

Power BI User on 05 Jul 2020 22:47:37

RE: Field Format - Report Wide

conditional formatting does not currently allow for negative values in red, positive in black--please fix!

Collin Quiring's profile image Profile Picture

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

RE: Field Format - Report Wide

Yes, please add conditional formatting for dimensions (Text). We often have business logic that is applied during ETL and stored in the fact or dimension table, and being able to do conditional formatting like in Excel on text values would be very useful.

Collin Quiring's profile image Profile Picture

Power BI User on 05 Jul 2020 22:45:29

RE: Field Format - Report Wide

I need to be able to have negative numbers automatically adjust the font color to red.

Collin Quiring's profile image Profile Picture

Devarshi on 05 Jul 2020 22:43:24

RE: Field Format - Report Wide

This is a very basic feature to show negative value in red color

Collin Quiring's profile image Profile Picture

Phillip on 05 Jul 2020 22:41:00

RE: Field Format - Report Wide

Also conditional formatting should be able to use a different measure for the min or max values. Like explained in this suggestion.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17266151-conditional-formatting-based-on-a-different-measur

Collin Quiring's profile image Profile Picture

Phillip on 05 Jul 2020 22:41:00

RE: Field Format - Report Wide

Quoting from Mike "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
"

I have to agree as well. It's almost as if the Power BI developers are a bunch of Javascript programmers who know nothing of the decades of solid UX knowledge Microsoft has gained over 4 decades and are now relearning old lessons.

Also as far as looking for previously registered ideas is concerned, there doesn't seem to be a way to sort the search results by number of votes. Votes could be spread out over twenty duplicates and you end up wasting your vote on one copy that has zero votes instead of the duplicate with over 75 votes.

Collin Quiring's profile image Profile Picture

Scott A on 05 Jul 2020 22:39:23

RE: Field Format - Report Wide

This is a BASIC feature that should have been implemented a long time ago.

Collin Quiring's profile image Profile Picture

Andrew McDonald on 05 Jul 2020 22:38:42

RE: Field Format - Report Wide

Red, Yellow, Green formatting is key when it comes to dashboard development. All Managers want to have that visual key.

Collin Quiring's profile image Profile Picture

Power BI User on 05 Jul 2020 22:37:05

RE: Field Format - Report Wide

Sounds a lot like this suggestion: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13757925-dynamically-specify-data-colour-using-column-e-g

Collin Quiring's profile image Profile Picture

Marc on 05 Jul 2020 22:36:28

RE: Field Format - Report Wide

Must have feature, would make things a lot easier!

Merged Idea (15)