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!
Hi all. I see so many issues with the matrix incorrectly calculating values, now it's my turn to add my problem to the group.
when i calculate month to month % it works fine.
But when I attempt to calculate by Quarter over Quarter or Year over Year, incorrect Results.
My example below illustrates this.
For example, here is the matrix of one record
390/39 of course is not = to 1009.40
Switching it from matrix to table doesn't change the %
How do i resolve this so that the % are correctly calculating? Any ideas?
Always appreciate help.
Thanks, Steven Taub.
So it looks like the error is some how occuring before the data is actually posted into the visual. Rounding errors maybe?
Do you have any suggestions for me on resolving this?
Thanks...
Solved! Go to Solution.
Hey @StevenT ,
how do your measures look like?
How is the data model?
What result do you expect?
Can you provide a sample file?
If you want someone to help you, then add more details. Nobody knows why the result is like that if you don't tell which calculation you are using.
Best regards
Denis
Actually, I was able to complete this task and I figured out what i was doing wrong.
I was incorrectly identifying a measure that wasn't matching the Month Quarter and Year and I resolved it.
Thanks!
Hey @StevenT ,
how do your measures look like?
How is the data model?
What result do you expect?
Can you provide a sample file?
If you want someone to help you, then add more details. Nobody knows why the result is like that if you don't tell which calculation you are using.
Best regards
Denis
Vote for your favorite vizzies from the Power BI World Championship submissions!
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 |
|---|---|
| 57 | |
| 53 | |
| 42 | |
| 16 | |
| 16 |
| User | Count |
|---|---|
| 112 | |
| 106 | |
| 39 | |
| 36 | |
| 27 |