Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Inanna80
New Member

Colour data objects with DAX formula

I coloured values of the y-axis in Power BI using a Dax forumula

 

 

The following example 

Inanna80_0-1692716026928.png

This is working, when customer is a value used in the y-axis. 

Inanna80_2-1692716381087.png

 

 

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

Inanna80_1-1692716181146.png

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

vyangliumsft_0-1692863751099.pngvyangliumsft_1-1692863751100.png

If there is content or values in the legend field in the axis of Visual, you can only change the color manually.

vyangliumsft_2-1692863788349.png

vyangliumsft_3-1692863788349.png

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.

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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.

vyangliumsft_0-1692863751099.pngvyangliumsft_1-1692863751100.png

If there is content or values in the legend field in the axis of Visual, you can only change the color manually.

vyangliumsft_2-1692863788349.png

vyangliumsft_3-1692863788349.png

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.

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.