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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
fsim
Responsive Resident
Responsive Resident

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
fsim
Responsive Resident
Responsive Resident

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)
)

View solution in original post

1 REPLY 1
fsim
Responsive Resident
Responsive Resident

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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