Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I think it's not really complicated but I don't know how to do this.
I know how to trace a graph with data on columns but now my data are in rows.
Exemple:
Name Surname Score_September Score_October Score_November
Pierre X 15 16 12
Paul Y 12,5 13 15
Do you know how to trace a score graph with months on axis and name on legend?
Thank youuu !!! 🙂
Paul 🙂
Solved! Go to Solution.
I think that to get the result that you want, you will have to unpivote the Month columns.
To do this you should choose Edit Queries on the Home tab.
Then got to the query in question and select all of the month columns.
Next, on the Transform tab choos Unpivote Columns.
Finally, hit close and apply.
Now you should be able to create the visual that you are looking for.
Is this what you were looking for?
I think that to get the result that you want, you will have to unpivote the Month columns.
To do this you should choose Edit Queries on the Home tab.
Then got to the query in question and select all of the month columns.
Next, on the Transform tab choos Unpivote Columns.
Finally, hit close and apply.
Now you should be able to create the visual that you are looking for.
Is this what you were looking for?
Yes thank you !! 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |