Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
I would like to show the top 12 products sales volume in YTD 2024 vs. YTD 2023.
But I do not know how to do it in PBI.
Does any experts can provide some ideas or suggestions?
Thanks a lot in advance!
YTD 2023 | YTD 2024 | ||||||||
A | B | C | A | B | C | ||||
Product 1 | 0.5 | 1.7 | 0.8 | Product 1 | 1 | 2 | 1 | ||
Product 3 | 1.5 | 1.7 | 2.8 | Product 3 | 2 | 2 | 3 | ||
Product 5 | 0.5 | 2.7 | 0.8 | Product 5 | 1 | 3 | 1 | ||
Product 6 | 0.5 | 0.7 | 1.8 | Product 6 | 1 | 1 | 2 | ||
Product 8 | 2.5 | 1.7 | 2.3 | Product 8 | 3 | 2 | 2.5 | ||
Product 10 | 1.5 | 1.7 | 1.3 | Product 10 | 2 | 2 | 1.5 | ||
Product 13 | 1.5 | 1.7 | 1 | Product 13 | 2 | 2 | 1.2 | ||
Product 15 | 1.5 | 1.7 | 0.9 | Product 15 | 2 | 2 | 1.1 | ||
Product 16 | 1.5 | 1.7 | 0.8 | Product 16 | 2 | 2 | 1 | ||
Product 19 | 1.5 | 1.7 | 0.6 | Product 19 | 2 | 2 | 0.8 | ||
Product 20 | 1.5 | 1.7 | 0.7 | Product 20 | 2 | 2 | 0.9 | ||
Product 18 | 1.5 | 1.7 | 0.5 | Product 18 | 2 | 2 | 0.7 | ||
Product 21 | 0.15 | 0.15 | 0.15 | Product 22 | 0.1 | 0.1 | 0.1 | ||
Product 26 | 0.15 | 0.15 | 0.15 | Product 23 | 0.1 | 0.1 | 0.1 | ||
Product 29 | 0.15 | 0.15 | 0.15 | Product 24 | 0.1 | 0.1 | 0.1 | ||
Product 30 | 0.15 | 0.15 | 0.15 | Product 25 | 0.1 | 0.1 | 0.1 | ||
Product 31 | 0.15 | 0.15 | 0.15 | Product 26 | 0.1 | 0.1 | 0.1 | ||
Product 32 | 0.15 | 0.15 | 0.15 | Product 27 | 0.1 | 0.1 | 0.1 | ||
Product 33 | 0.15 | 0.15 | 0.15 | Product 28 | 0.1 | 0.1 | 0.1 |
Solved! Go to Solution.
There are custom visuals that you can create that will allow you to do this, but the easiest solution for now would be to create two side by side and the invert x-axis range and y-axis position on one of them...
To create Top 12, select each visual and filter by TopN in filter pane:
Proud to be a Super User!
There are custom visuals that you can create that will allow you to do this, but the easiest solution for now would be to create two side by side and the invert x-axis range and y-axis position on one of them...
To create Top 12, select each visual and filter by TopN in filter pane:
Proud to be a Super User!
Thank you a lot!!!