Amanda Cofsky on 04 Oct 2014 01:20:39
Power BI's visualizations have colors assigned automatically. It should be possible to set a color when a value is reached (e.g. always show negative bars in red) or for a particular color in a legend (e.g. always show Microsoft datapoints as blue)
- Comments (79)
- Merged Idea (2)
RE: Set Colors and Conditional Formatting in visuals
This is such a fundamental need that Power BI still hasn't solved for. Would be great to justify values for color ranges especially when anything outside of a range should be red. Would like to be able to choose how far outside of a range determines specific colors similar to KPI's in Power Pivot.
RE: Set Colors and Conditional Formatting in visuals
I want to set coloring based on the value or range (conditional coloring). Unless I am missing something, this cannot be done in PBI. SSRS has lot of flexibility with its expressions support for most of the attributes. PBI is more static in nature and it applies to all attributes like Coloring, Font Weight, etc.
RE: Set Colors and Conditional Formatting in visuals
This should not be marked as completed. The request states to have colors "assigned automatically". Right now, the only color assignments are manual. There is no way to link the color to a calculated field. For instance, I would like to have a gauge appear red when below target and green when it is at or above it.
RE: Set Colors and Conditional Formatting in visuals
Wow - SSRS out performed Power Bi in so many ways, not to mention 3rd party apps.. This is a fundamental reporting/dashboarding concept.
RE: Set Colors and Conditional Formatting in visuals
This would be a very big value add. If this software expects to compete with Tableau, SAS, Looker, etc. more control of color formatting is needed.
RE: Set Colors and Conditional Formatting in visuals
Best site or sharepoint where I can found tutorials for conditional formatting and for custom sorts in power BI
RE: Set Colors and Conditional Formatting in visuals
Gauge conditional formatting and multiple target tiers would be greatly beneficial (i.e. minimum goal xx%, bonus goal yy%)
RE: Set Colors and Conditional Formatting in visuals
Conditional formatting is missing. Idea was implemented half-way ;)
RE: Set Colors and Conditional Formatting in visuals
Dynamic Conditional Formatting is really important to our business users. Please add this function to Power BI.
RE: Set Colors and Conditional Formatting in visuals
I cant see this in the desktop app?