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...
Greg_Deckler
Community Champion
Community ChampionIt's going to be next to impossible to troubleshoot this without the data Anonymous - can you share the PBIX or a representative sample?
Please find the mock data.
| Approver | ProjectID | Duration |
| a1 | p1 | 2 |
| a1 | p2 | 4 |
| a1 | p3 | 10 |
| a2 | l1 | 1 |
| a2 | l2 | 1 |
| a2 | l3 | 1 |
| a3 | f1 | 15 |
| a3 | f2 | 15 |
| a3 | f3 | 20 |
| a3 | f4 | 20 |
Calcuated Columns/Measures:
projects>3 days = IF (my[Duration] >3, 1, 0)
count of projects = DISTINCTCOUNT(my[ProjectID])
%3 Days Outstanding = SUM(my[projects>3 days])/[count of projects]
Age Group = IF(my[Duration] <= 3, "<=3 Days",IF (my[Duration] >3 && my[Duration] < 6,"> 3 and < 6 Days",">=6 Days"))