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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have some order tables (below is just a sample ) based on the I need to show few stats
| Month | order | total_items | Value | PIN |
| 2023-JAN | 123 | 12 | 1000 | 400012 |
| 2023-JAN | 124 | 2 | 50 | 400045 |
| 2023-JAN | 456 | 5 | 300 | 500067 |
| 2023-FEB | 652 | 3 | 200 | 408222 |
| 2022-JAN | 34 | 9 | 500 | 400045 |
| 2022-JAN | 45 | 1 | 10 | 500067 |
| 2022-FEB | 50 | 2 | 60 | 506675 |
I need to show(in matrix table chart) the last two months' total items and their total value and along with the same month last year like below
I can display the current two months but I am not sure how to show preYrcount and the value of same month in same row ?
Please provide some direction to display this details in power bi?
NetCount : Total Item count of a month
Netvlaue : Total value of a month
PreYrCount : Total item count of the same month is last year.
Hi,
I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file if it suits your requirement.
All measures are in the attached pbix file.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 21 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 35 | |
| 31 | |
| 20 | |
| 13 | |
| 10 |