Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
jjudy
Helper I
Helper I

Measure displays different values on rows than on columns in matrix visual

Hi all, This is driving me crazy. I have a simple sum calculation that I'm putting in a matrix visual with a fiscal year and month to slice it. When it put the Fiscal year and month on rows, I get the correct calculation. When I switch it to columns, it gets crazy pants as shown below.

 

2tablesSS.png

 

Measure is 

Total = SUM('Table'[_total])
 
Model is:
modelss.png

 

Fiscal year is offset by 3 months and the month field is sorted by the alternate sort
 
PeriodTabless.png

 

fact table is just random values with a period key
Factss.png

 

What is even going on?
 
Help!
 
Sample file here: MatrixError 
1 ACCEPTED SOLUTION
jjudy
Helper I
Helper I

Alrighty, based on @bchager 's first response, It occurred to me that the first month was actually displaying the subtotal and labeling it as a category. I went in the Format visuals pane and turned the Column subtotals on and then off again. It's working fine now. Going to raise a ticket with MS since this is definitely a replicable bug.

 

Thanks so much!

View solution in original post

6 REPLIES 6
jjudy
Helper I
Helper I

Alrighty, based on @bchager 's first response, It occurred to me that the first month was actually displaying the subtotal and labeling it as a category. I went in the Format visuals pane and turned the Column subtotals on and then off again. It's working fine now. Going to raise a ticket with MS since this is definitely a replicable bug.

 

Thanks so much!

bchager6
Super User
Super User

I see what the 31,894 is composed of after bringing in the PeriodKey field. Could it be because you don't have any date fields in your matrix?

bchager6_0-1705013058139.png

 

It's a thought but without a date field, shouldn't they act as categories anyway? Why would it add data that isnt actually on the periodkey in the slot of October?

 

On a lark I modded the initial model with additions to the date table with the sort reinstated as so:

 

NewDatess.png

 

And ended up categorically with the same result.

 

Categorically.png

 

What could be causing this behavior?

I'm not sure. I also noticed a disconnect between the PeriodKey in both tables. One of them has a 109 and one only goes up to 108. I'm spitballing here but is that a referential integrity issue?

Most appreciated, but in the larger model that this initially showed up in, there's no referential integrity issues. I'll test it here though.

 

No it isn't that easy. I just fixed it in the model and it stays the same 😞

I've read about issues some users are having with visualizations with the December 2023 release. Have you tried using a third party matrix from the marketplace to see if it behaves the same or differently?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.