Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
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.
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.
@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
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |