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

Matrix visual not filtering correctly when new blank rows feature is on

I am on version 2.129.905.0 64-bit (May, 2024).

I am using the matrix visual and have tried using the new 'blank rows' feature. When the 'blank rows' is on and I filter between past years it filters fine, but as soon as I switch to 2024 it does not update fitler the visual (it remains as the previously selected year's data, in this case 2023). If I switch 'blank rows' off the visual filters correctly.

 

BlankRowsBug.png

Status: Investigating

Hi  @EHA_SD 

As you said, I enabled Blank rows , and then did the filtering on the time, the filtering is working, and it doesn't happen as you said. Can you describe in detail what you did?

Recording 2024-05-29 at 01.41.47.gif

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Investigating

Hi  @EHA_SD 

As you said, I enabled Blank rows , and then did the filtering on the time, the filtering is working, and it doesn't happen as you said. Can you describe in detail what you did?

Recording 2024-05-29 at 01.41.47.gif

Best Regards,
Community Support Team _ Ailsa Tao

EHA_SD
Advocate I

I had two matrices, one for Jan to Jun the other for Jul to Dec.

 

With "blank rows" on, when I switch the slicer from 2023 to 2024, the dates that did not have data yet (i.e. Q3 and Q4 of 2024) did not filter out as expected as what happens with 'blank rows' off. Instead the existing data stayed in its place (i.e. 2023):

BlankRowsBug.gif

v-yetao1-msft
Community Support

Hi @EHA_SD 

At the moment I can't restore your problem on my end. Can you provide your sample for testing (removing sensitive information)?

 

Best Regards,
Community Support Team _ Ailsa Tao

EHA_SD
Advocate I

I think you should be able to download the file?

External share - Google Drive