Forum Discussion
Colour data objects with DAX formula
I coloured values of the y-axis in Power BI using a Dax forumula
The following example
This is working, when customer is a value used in the y-axis.
How can I re-formulate the Dax formula, if I want to use customer in a visual with legend?
see below unfortunately the colours are not taken into account
Hi Inanna80 ,
According to research: in the stacked column chart, we only have the fx option to customize the color when dragging the field to both the Y and X axes.
If there is content or values in the legend field in the axis of Visual, you can only change the color manually.
You can also submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Inanna80 ,
According to research: in the stacked column chart, we only have the fx option to customize the color when dragging the field to both the Y and X axes.
If there is content or values in the legend field in the axis of Visual, you can only change the color manually.
You can also submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.