Forum Discussion
Line Chart, Measures
I am trying to create a line chart in PBI using four different columns to show the count of "delayed" status in Q1, Q2, Q3, and Q4. The data looks like the below. I have created several count columns, several measures and nothing is working. It shows up like this as a bar chart using a different table that has Q1-Q4 down the rows and a count column of "delayed", but I want them to be separate values instead of grouped values. The goal is for the line chart to look like a trend line saying the number of delayed actions as the year progresses.
Anonymous
maybe you can try to unpivot columns
Unpivot columns - Power Query | Microsoft Learn
then you will have two columns, quarter and status.
That will be easier for us to do the visualization.
1 Reply
- ryan_mayuSuper User
Anonymous
maybe you can try to unpivot columns
Unpivot columns - Power Query | Microsoft Learn
then you will have two columns, quarter and status.
That will be easier for us to do the visualization.