Forum Discussion
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
- ZeshansaifFrequent Visitor
Thankyou so much for your help 🙂
- Ritaf1983Super User
Happy to help 🙂
- Ritaf1983Super User
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