Using Fields Parameter to Create a Measure for Dynamic coloring complete column clustered /bar chart

[Zeshansaif]

I have a column chart i.e. "Sales by Category", I want a measure to change the colors of all columns of Y-axis based on field parameters. In the chart, Y-axis is Field Parameter, while X-axis is Category.

I tried using the following measures;

Color Measure =
SWITCH (
SELECTEDVALUE ( 'Monthly Comparison'[Monthly Comparison Fields] ),
"Sales", "#00FF00", // Green color for Sales
"Profit", "#FF0000", // Red color for Profit
"Number of Orders", "#0000FF", // Blue color for Number of Orders
"#EB895F" // Default color for other values
)

However, no matter what field I select, I am getting default color.

[Zeshansaif]

Thankyou so much for your help 🙂

[Ritaf1983]

Happy to help 🙂

[Ritaf1983 · Accepted solution]

Hi @Zeshansaif 

Since a parameter table is a table designed for parameters, the engine does not allow you to apply conditions to it.

You simply need to add a helper column and apply the formula you wrote, which is correct in its logic, to the column you added.

Result :

The pbix with my example is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly