cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cham Member
Member

undefined

Hi,

 

I created a mesure using my data set in Power BI. Measure = Price/Revenue

 I want to add conditional formating for my bar chart. I used Name and Measure for my bar chart.

I want to create conditional format as follow,

Red=<18%
Yellow=25%
Green=>30%

 

My data set is follow,

NamePriceRevenue
A200100
B15050
C40078
D50045
E30020
F46790

 

 

I want to add conditional formatting as below. I want to show the shading in my bar chart as below,

 

CF.PNG

3 ACCEPTED SOLUTIONS

Accepted Solutions
Super User I
Super User I

Re: undefined

Hi @cham ,

 

Please try to use below setting.

undefined.PNG

 

Thanks.

Aiolos Zhao

View solution in original post

Super User I
Super User I

Re: undefined

I'm also glad to help you.

Could you please mark my reply as "accepted solution", so other people will know that the topic is sovled.

 

Thank you.

Aiolos Zhao

View solution in original post

Super User I
Super User I

Re: undefined

Hi @cham ,

Please try to use below setting:

undefined 2.PNG

Thanks.

Aiolos Zhao

View solution in original post

6 REPLIES 6
Super User I
Super User I

Re: undefined

Hi @cham ,

 

Please try to use below setting.

undefined.PNG

 

Thanks.

Aiolos Zhao

View solution in original post

cham Member
Member

Re: undefined

Yes it worked. Thank you so much.

Super User I
Super User I

Re: undefined

I'm also glad to help you.

Could you please mark my reply as "accepted solution", so other people will know that the topic is sovled.

 

Thank you.

Aiolos Zhao

View solution in original post

cham Member
Member

Re: undefined

Hi @AiolosZhao 

 

Can you please help me to do this as well.

 

I have the following sheet,

NameStatusDays
AGood80
BBad30
ABad20
AGood50
BGood20
CBad90

 

I want to add conditional formatting for the data set above,

 

Good =Green
Average=Yellow
Bad=Red

as below,

 

CF.PNG

 

Which chart i can use for this and how can i do the conditional formatting

Super User I
Super User I

Re: undefined

Hi @cham ,

Please try to use below setting:

undefined 2.PNG

Thanks.

Aiolos Zhao

View solution in original post

cham Member
Member

Re: undefined

Thank you so much

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors