Forum Discussion
hellojb
3 years agoFrequent Visitor
Pivot Measures
I created 5 measure that calculates the current count and projection of status A, B, and C.
| Status | Current | Q1 2023 | Q1 2023 | Q1 2023 | Q1 2023 |
| A | 250 | 280 | 300 | 320 | 350 |
| B | 80 | 85 | 90 | 88 | 92 |
| C | 50 | 40 | 44 | 30 | 10 |
I want to pivot the table so I can combine the measures in one table and create a line chart with the date in x axis and count in the y axis, and status as a legend.
| Status | Date | Count |
| A | Current | 250 |
| A | Q1 2023 | 280 |
| A | Q2 2023 | 300 |
| A | Q3 2023 | 320 |
| A | Q4 2023 | 350 |
| B | Current | 80 |
| B | Q1 2023 | 85 |
| B | Q2 2023 | 90 |
| B | Q3 2023 | 88 |
| B | Q4 2023 | 92 |
I was able to create this table using summarizedcolumn but I need to apply filters and dynamically update the table so I need to create a measure that will allow me to pivot the measure to this view.
1 Reply
- PaulDBrownCommunity Champion
PLease follow the recommendations in this thread to help us help you:
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523