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 (119)
- Merged Idea (15)
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!!
RE: Field Format - Report Wide
conditional formatting does not currently allow for negative values in red, positive in black--please fix!
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.
RE: Field Format - Report Wide
I need to be able to have negative numbers automatically adjust the font color to red.
RE: Field Format - Report Wide
This is a very basic feature to show negative value in red color
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
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.
RE: Field Format - Report Wide
This is a BASIC feature that should have been implemented a long time ago.
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.
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