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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Satish_Kumar
Helper V
Helper V

color coding

Hi,

I am stuck in some where in my dashboarding when i got challenge i.e. i have to create a dashboard which compare two data (data of last year to this year data till now) if i am in profit the color of my graph showing the data should come in Green Color and if i face loss then it will come in Red Color and if their is no loss or profit than it should be in Pink Color.

 color coding.png

2 REPLIES 2
Satish_Kumar
Helper V
Helper V

Hi,

I am stuck in some where in my dashboarding when i got challenge i.e. i have to create a dashboard which compare two data (data of last year to this year data till now) if i am in profit the color of my graph showing the data should come in Green Color and if i face loss then it will come in Red Color and if their is no loss or profit than it should be in Pink Color.

 

 

color coding.png

 

v-yulgu-msft
Employee
Employee

Hi @Satish_Kumar,

According to your description, you want to dynamically change the color of column bars in a chart by comparing the value of last year and this year, right?

 

However, as I know, it is not supported to conditionally change the color of bars in PowerBI. It is allowed to manually setting different colors according to categories in axis under the format tab in data color option.
1.PNG

 

If you have any other question, please feel free to ask.

 

Best regards,
Yuliana Gu

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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