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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.