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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
jaytrice26
Helper I
Helper I

How do I color code items within a group

Hello - I have a clustured column chart. Within it I have grouped items together so that its not so big. However I still want to be able to show that there are different items in each column by color. i.e. Laptops bar consists of :professional laptops, high-performance laptops, professional macbooks, high-performance macbooks, etc. I would like each "model" to be a different color. Is that possible?

jaytrice26_0-1730154228003.png

 

1 REPLY 1
PhilipTreacy
Super User
Super User

Hi @jaytrice26 

 

Download PBIX file with examples below

 

No you can't do that with the Clustered Column, the color is applied to the column as a whole.

 

But you can do this with a Clustered Column.

 

With data like this

 

PhilipTreacy_4-1730159526554.png

 

 

You get this

 

PhilipTreacy_3-1730159506627.png

 

 

In the visual settings you need to turn off the Legend, and turn on Data Labels and Data Labels -> Value and Title

 

PhilipTreacy_2-1730159487848.png

 

 

If you have data that you want to look at over time like this

 

PhilipTreacy_0-1730160027567.png

 

You can create this

 

PhilipTreacy_1-1730160054898.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!


Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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