Forum Discussion
Combine Table & Stacked Bar Chart
All,
I have a requirement to develop a report like below. Just removed the approver name due to security reason, think of some names under Approver.
This is not a single chart, i just added 2 charts table & stacked bar chart and applied 'sent back' for stacked bar chart. I have 3 slicers.
If i select only one or two names then the report looks like this.
But i am looking to align this bar straight to the name instead of shrinking to its entire size. is it possible?
26 Replies
There 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% Anonymous - It is under Conditional Formatting oddly enough.
