cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fsim Regular Visitor
Regular Visitor

missing data in matrix rows , but subtotal is correct

hi there ! 

I came up yesterday on this strange matrix's behaviour. As shown on the pic1, I have a matrix showing the number of repports encoded by our sales ordered by a day hierarchy (year, week number, day) . For some unknown reason, on week 30 (and a couple of older) , the subtotals of repports are ok but the data are missing from the grid.

I can see the data in the tooltip, Howeverthe missing data are shown if I filter on one single sale (2nd picture) or if I remove the week number from the hierarchy. 

 

 

has someone any idea ? 

thanks !

 

fred

 

bug.pngbug2.png

1 ACCEPTED SOLUTION

Accepted Solutions
fsim Regular Visitor
Regular Visitor

Re: missing data in matrix rows , but subtotal is correct

I self reply to my post with a solution.

I re- created the date hierarchy (adding the monthname) and replaced the one I used in the matrix and, Tadaa !,  the data shown up. 

then I removed the monthname. And the data didn't vanish.

 

I used the new hierarchy in another matrix and the data vanished again. Put the monthName back in , then removed it and the data stayed on. 

Sounds like a bug somewere in the use of this hierarchy

 

for the record the date are generated through this 

 

Date =
ADDCOLUMNS (
CALENDAR (DATE(2018;1;1); DATE(2022;12;31));
"DateAsInteger"; FORMAT ( [Date]; "YYYYMMDD" );
"Year"; YEAR ( [Date] );
"Monthnumber"; FORMAT ( [Date]; "MM" );
"DayNumber"; FORMAT ( [Date];"DD");
"YearMonthnumber"; FORMAT ( [Date]; "YYYY/MM" );
"YearMonthShort"; FORMAT ( [Date]; "YYYY/mmm" );
"MonthNameShort"; FORMAT ( [Date]; "mmm" );
"MonthNameLong"; FORMAT ( [Date]; "mmmm" );
"DayOfWeekNumber"; WEEKDAY ( [Date] );
"DayOfWeek"; FORMAT ( [Date]; "dddd" );
"DayOfWeekShort"; FORMAT ( [Date]; "ddd" );
"Quarter"; "Q" & FORMAT ( [Date]; "Q" );
"WorkingDay"; (weekDAY( [Date] ) > 1 && WEEKDAY( [Date] ) < 7 ) * 5.5;
"YearQuarter"; FORMAT ( [Date]; "YYYY" ) & "/Q" & FORMAT ( [Date]; "Q" );

"Week"; WEEKNUM([Date];2)
)

1 REPLY 1
fsim Regular Visitor
Regular Visitor

Re: missing data in matrix rows , but subtotal is correct

I self reply to my post with a solution.

I re- created the date hierarchy (adding the monthname) and replaced the one I used in the matrix and, Tadaa !,  the data shown up. 

then I removed the monthname. And the data didn't vanish.

 

I used the new hierarchy in another matrix and the data vanished again. Put the monthName back in , then removed it and the data stayed on. 

Sounds like a bug somewere in the use of this hierarchy

 

for the record the date are generated through this 

 

Date =
ADDCOLUMNS (
CALENDAR (DATE(2018;1;1); DATE(2022;12;31));
"DateAsInteger"; FORMAT ( [Date]; "YYYYMMDD" );
"Year"; YEAR ( [Date] );
"Monthnumber"; FORMAT ( [Date]; "MM" );
"DayNumber"; FORMAT ( [Date];"DD");
"YearMonthnumber"; FORMAT ( [Date]; "YYYY/MM" );
"YearMonthShort"; FORMAT ( [Date]; "YYYY/mmm" );
"MonthNameShort"; FORMAT ( [Date]; "mmm" );
"MonthNameLong"; FORMAT ( [Date]; "mmmm" );
"DayOfWeekNumber"; WEEKDAY ( [Date] );
"DayOfWeek"; FORMAT ( [Date]; "dddd" );
"DayOfWeekShort"; FORMAT ( [Date]; "ddd" );
"Quarter"; "Q" & FORMAT ( [Date]; "Q" );
"WorkingDay"; (weekDAY( [Date] ) > 1 && WEEKDAY( [Date] ) < 7 ) * 5.5;
"YearQuarter"; FORMAT ( [Date]; "YYYY" ) & "/Q" & FORMAT ( [Date]; "Q" );

"Week"; WEEKNUM([Date];2)
)

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 391 members 4,127 guests
Please welcome our newest community members: