Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. 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 |
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!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |