Forum Discussion

Zeshansaif's avatar
Zeshansaif
Frequent Visitor
2 years ago
Solved

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

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.

  • 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

3 Replies

  • 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