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...
  • Ritaf1983's avatar
    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