Tom Andrews on 02 Sep 2015 16:45:54
It would be great if you could do conditional formatting throughout all of Power BI Desktop. e.g. text boxes have conditional formatting based on your data. It would be great if conditional formatting also worked with the different bars in bar charts etc.
- Comments (50)
RE: Conditional Formatting throughout
Like to see conditional formatting for values in a matrix. ie Negative = Red font and positive = Black.
RE: Conditional Formatting throughout
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!
RE: Conditional Formatting throughout
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????
RE: Conditional Formatting throughout
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.
RE: Conditional Formatting throughout
Really really would like to see conditional formatting for values in a matrix. ie Negative = Red font and positive = Black. Please add!!
RE: Conditional Formatting throughout
conditional formatting does not currently allow for negative values in red, positive in black--please fix!
RE: Conditional Formatting throughout
I need to be able to have negative numbers automatically adjust the font color to red.
RE: Conditional Formatting throughout
This is a very basic feature to show negative value in red color
RE: Conditional Formatting throughout
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: Conditional Formatting throughout
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.