Forum Discussion
Multiple Stacked Columns stacked with line chart
Based on data, could any one help me how to generate chart as provide?
Data:
| Date | Incoming-New | Incoming-Age | Transfer out | RESOLVED | Current open |
| 1-Jul | 5 | 1 | 1 | 2 | 1 |
| 2-Jul | 3 | 0 | 0 | 2 | 2 |
| 3-Jul | 4 | 0 | 0 | 5 | 1 |
| 4-Jul | 3 | 1 | 0 | 1 | 3 |
| 5-Jul | 2 | 0 | 1 | 4 | 1 |
| 6-Jul | 0 | 0 | 0 | 0 | 1 |
| 7-Jul | 1 | 0 | 0 | 2 | 0 |
| Stacked | Stacked | Line |
Chart
Hi ajitk15 ,
Thanks amitchandak for the quick reply. Please allow me to offer other idea:
(1) Click "Transform Data" to enter Power Query, select the [Date] column, right-click "Unpivot Other Columns", then copy the table, filter the [Attribute] column, and then click "Close and Apply".
(2) Create a model relationship.
(3) Create a measure.
Current open = CALCULATE(SUM('Table'[Value]),FILTER('Table',[Attribute]="Current open"))(4) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
ajitk15 , if these are measures refer to my approach
Creating Clustered Stacked Bar Visuals with Calculation Groups and Measures: https://www.youtube.com/watch?v=Z1Jx1hPtzbM&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
Use Creating Clustered with line, to have one measure on line
Or check out this visual
Hi ajitk15 ,
Thanks amitchandak for the quick reply. Please allow me to offer other idea:
(1) Click "Transform Data" to enter Power Query, select the [Date] column, right-click "Unpivot Other Columns", then copy the table, filter the [Attribute] column, and then click "Close and Apply".
(2) Create a model relationship.
(3) Create a measure.
Current open = CALCULATE(SUM('Table'[Value]),FILTER('Table',[Attribute]="Current open"))(4) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
