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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
dsmitha
Responsive Resident
Responsive Resident

Bar chart columns colour based on DATA

Hi,

In our dashboard we have a bar chart visual which is based on sales. Our main items are mobile handsets of a specific brand. Our brand has different colours of handsets,  we would like to show the  handsets sales based on their colors  in the bar chart , i.e. for red colour handsets  the bar should in red colour like that.

kindly advise how to make this happen

 

regards,

dsmitha

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Hi @dsmitha 

 

Download example PBIX file

 

Create a conditional formatting rule for the bar chart like this

 

cfbar.png

 

cfbarch.png

 

regards

 

Phil

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

2 REPLIES 2
PhilipTreacy
Super User
Super User

Hi @dsmitha 

 

Download example PBIX file

 

Create a conditional formatting rule for the bar chart like this

 

cfbar.png

 

cfbarch.png

 

regards

 

Phil

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


HI PhilipTreacy,

 

Thank you very much, this is what i was looking for

 

double kudoz

 

regrads,

smitha

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.