Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote 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!!!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |