Power BI
NewAdd an Fx button next to each Value when using multiple Values in all Bar Chart visualizations
Richard Beaumont on 13 Jul 2021 22:38:32
Please allow us to assign conditional colors in any Bar Chart when we are using more than one Value.
BTW. The Clustered Column Chart is our priority :)
Conditional colors work well when using one Value. We can assign conditional colors via 'Format | Data Colors | Default Color 'Fx' | Format By: Field Value - then we can select a measure eg:
Chart Color Code =
VAR ColorCode = IF('Key Measures'[Chart Delta] >0 , 1, 0)
VAR Result =
SWITCH (
TRUE(),
ColorCode = 1 , "#00B84D",
ColorCode = 0 , "#FD625E"
)
RETURN
Result
When an additional Value is added via Fields| Values the first value loses the condition and via Format | Data Colors we can only select static colors for each Value. ie in addition to the manual color selection of each value please add an Fx button next to each Value . Thanks.
- Comments (2)
RE: Add an Fx button next to each Value when using multiple Values in all Bar Chart visualizations
The Fx button disappears when more than 1 value is added to X axis in Clustered Bar and Column chart. Need this feature at the earliest.
RE: Add an Fx button next to each Value when using multiple Values in all Bar Chart visualizations
BTW. This was when using small multiples