Skip to main content
Microsoft Idea

Power BI

New

Add an Fx button next to each Value when using multiple Values in all Bar Chart visualizations

Vote (2) Share
Richard Beaumont's profile image

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)
Richard Beaumont's profile image Profile Picture

Jaco Thampi Mathew on 25 Apr 2023 04:44:32

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.

Richard Beaumont's profile image Profile Picture

Richard Beaumont on 13 Jul 2021 22:46:31

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