Forum Discussion

harirao's avatar
harirao
Post Prodigy
1 year ago
Solved

Assistance Required: Line and Clustered Column Chart Color Coding

Hi All, I have created a Line and Clustered Column Chart by unpivoting the Quarter columns and adding a new table for Quarter sorting. I also established a relationship between both "Attribute" colu...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the reply from Fowmy, please allow me to provide another insight.

    Hi harirao ,

     

    You can try this custom visual: Multiple Axes Chart - XViz.

     

    This visual allows for setting conditional formatting for measures.

     

    Please refer to the following steps.

    Click on the pencil symbol to enter the editing screen.

     

    Under the 'Conditional Formatting' tab, you can add rules to set the color for measures.
    In my example, I have set a different color for each quarter for the 'Fcst' measure.

    You can continue to assign different colors to other measures based on quarters.

     

    Please see the attached pbix for reference.

     

    Best Regards,
    Dengliang Li

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