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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Turambar
Frequent Visitor

Table Databars with color coding - custom visual?

I am trying to find a way to add colors based on a categorical variable to data bars on a table visual. Below is an example of what I need it to look like but the colors for the data bars in car sales YoY must correspond to the region that the market is in. For example if the market is west then blue, central red, east coast yellow. Users must be able to have the option to sort by population as well. Is there a custom visual that I can use to accomplish this?

 

MarketCar sales % YoYPopulation
Los Angeles==========3,800,000
Chicago========2,700,000
Detroit=====630,000
1 ACCEPTED SOLUTION

As I said this option is just not available....

You can vote the idea about this option here :

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=7251c356-bd01-ed11-b5cf-281878de6c19

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

3 REPLIES 3
Ritaf1983
Super User
Super User

Hi @Turambar 

Unfortunately, this functionality is unsupported.

There is some workaround to combine it with a regular bar chart

Please refer to the linked discussions:

https://community.fabric.microsoft.com/t5/Desktop/Multi-Color-Data-Bars-in-Matrix/td-p/2837571

https://community.fabric.microsoft.com/t5/Desktop/Can-we-change-the-colors-of-data-bars-In-table/m-p...

 

My personal recommendation is just to use a matrix with your wanted areas, I explained here why :

My attention-span-challenging graph (madeiradata.com)

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

 

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

I've done it for other reports in the past but a matrix next to the chart will not work in this case. Users need to be able to have the option to sort the bars by the % YoY value that the bars visualize or population which would be the numbers to the right of it. That's why I was curious if it had been accomplished with a custom visual.

As I said this option is just not available....

You can vote the idea about this option here :

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=7251c356-bd01-ed11-b5cf-281878de6c19

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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