Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
Market | Car sales % YoY | Population |
Los Angeles | ========== | 3,800,000 |
Chicago | ======== | 2,700,000 |
Detroit | ===== | 630,000 |
Solved! Go to 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
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
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
97 | |
69 | |
46 | |
39 | |
33 |
User | Count |
---|---|
163 | |
110 | |
61 | |
51 | |
40 |