Forum Discussion
Combine Table & Stacked Bar Chart
Community ChampionThere is a 'data bars' option for matrix visualizations that people have used to create condensed bar charts like what you show. However, I do not believe that solution works for stacked bar charts. You could possibly do it with an SVG graphic. Like this for example: https://community.powerbi.com/t5/Quick-Measures-Gallery/SVG-Microchart-Harveyball-and-Harveybox/td-p/489599
If you provide sample data I could give this a whirl, it has been awhile since I created an SVG graphic so could be fun. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
I didnt see 'Data bar' option in the Matrix visual. is this introduced in the latest version? I'm using quite old version for now.
2.71 (July 2019 Version) - Have to upgrade
Please find below the sample data. There is a custom column created for Age Group.
Age Group = IF(my[Duration] <= 3, "<=3 Days",IF (my[Duration] >3 && my[Duration] < 6,"> 3 and < 6 Days",">=6 Days"))I used Approver, Count of ProjectID & Age Group for the "100% Stacked Bar Chart".Approver count of projects Average of Duration %3 Days Outstanding a1 23 23 100% a2 1 102 100% a3 2 1 0% a4 4 68 100% a5 1 8 100% a6 1 23 100% a7 11 8 100% a8 22 10 100% a9 4 1 0% a10 7 19 100% a11 13 76 100% a12 1 102 100% a13 19 46 95% a14 141 39 75% a15 2 37 50% a16 9 69 100% a17 6 23 33% a18 1 81 100% a19 1 3 0% - Greg_Deckler
Anonymous - It is under Conditional Formatting oddly enough.
Yes, I Can see that option, but it looks like it will not fulfil my requirement.
It looks like SVG can be the solution for this, but it is bit complex to understand for me (As a beginer to PowerBI)
How about using R for this scenario?