cancel
Showing results for 
Search instead for 
Did you mean: 
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
Microsoft
Microsoft

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors