Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 !! 🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
89 | |
81 | |
65 | |
64 | |
59 |
User | Count |
---|---|
171 | |
115 | |
109 | |
74 | |
69 |