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 All,
I have created a line graph which has the year month on X Axis and 4 measures displayed on Y Axis. See following Image:
I would like to take the analysis one step further and add another dimension (Person) to this graph.
So essentially what i would like to achieve is select two or three persons from a filter and then the graph will show instead of 4 lines, 8 lines for the 2 persons (4 services for each one of them) and 12 lines for the 3 persons. This will help me compare the performance between the persons im looking at.
I tried to do that on PowerBi but with no luck. Is this functionality available on the software?
Attached on this link is a spreadsheet where on the first sheet i show the lines for one person and on the second sheet i have a sample dataset for 3 persons. Based on the data from the second sheet i would like to create the relevant line graph where i will show 12 lines.
Thank you
Solved! Go to Solution.
Hi themistoklis,
To achieve your requirement, click query editor-> transform->click on [service1], [service2], [service3] and [service4]-> unpivot columns.
Then click add columns-> custom column to merge column [person] and [attribute] like below;
Then applied and close, create a line chart and a slicer on person column.
Regards,
Jimmy Tao
Hi themistoklis,
To achieve your requirement, click query editor-> transform->click on [service1], [service2], [service3] and [service4]-> unpivot columns.
Then click add columns-> custom column to merge column [person] and [attribute] like below;
Then applied and close, create a line chart and a slicer on person column.
Regards,
Jimmy Tao
Hello @v-yuta-msft
This indeed works great on the data and when the 4 services belong to an existing table
In my case these 4 services are calculated measures (4 fields) in PowerBi and they dont actually belong to an existing table.
Is there a way if these are calculated measures to display them on the graph, or they all need to be on an existing table?
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |