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.
Hi All,
I am trying to plot the rank of a company over the past 4 quarters.
Y-axis: Ranking
X-axis: Quarters
Legend: Comapny (One line for each company)
My data is shown below.
I tried using scatter charts and line charts but CP ID goes to the x-axis (see bwlow) and I cant move the values around in the fields page. Any ideas on how to solve this? Thqanks in advance for all the help!
Solved! Go to Solution.
Hi @NNaj ,
It is hard to calculate across multiple columns, I'd like to suggest you to 'unpivot columns' on your quarter fields(at query editor side), then you can write a formula to rolling calculate over these quarter ranges. (id to axis, attribute as legend, measure as value)
Regards,
Xiaoxin Sheng
Hi @NNaj ,
It is hard to calculate across multiple columns, I'd like to suggest you to 'unpivot columns' on your quarter fields(at query editor side), then you can write a formula to rolling calculate over these quarter ranges. (id to axis, attribute as legend, measure as value)
Regards,
Xiaoxin Sheng
Hi @v-shex-msft ,
Thank you for your response. Just a quick follow up question, is it possible to unpivot tables while they are in a visual? My table is a visual on a page and I used measures to calculate the rankings.
Regards,
Nader
HI @NNaj ,
You can use the matrix visual to expand unpivoted fields.(id to rows, attribute to columns, measure as value)
BTW, you can also use duplicate query feature to create a backup table to do calculation with the original table structure.
Regards,
Xiaoxin Sheng
Hi @NNaj ,
not sure what you are looking for on this, however to better compare numbers by Quarters use Line chart and change formatting as per attached screenshot.
let me know if it helps.
Regards,
Washivale
Hi Washivale,
Thanks for your reply.
I sketched the graph I am trying to make below.
The graph in my original post is the outcome of using the line graph, and I am unable to make CP_ID the legend and plot how the rank of each ID changes over the 4 periods.
I hope this explains what I am trying to achieve.
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 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |