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 a...
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% |
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?