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 Cate...
Need Help
Tips and Tricks
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

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