Forum Discussion
Assistance Required: Line and Clustered Column Chart Color Coding
- Anonymous1 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.
harirao
It's not possible to assign different color codes to each BASE FCST Quarter in a Line and Clustered Column Chart when multiple values (measures) are assigned to the X-axis. The reason is that Conditional Formatting is disabled in Power BI when multiple measures are plotted on the same axis.
I you could explain your objectives, I would be to suggest other alternatives