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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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