cancel
Showing results for 
Search instead for 
Did you mean: 

Bug in Power BI Service: Matrix shows values even it should be emtpy with filter selection

I have recognized wrong filter behavior for matrix visual when filtering via filter pane in Power BI Service, while in Power BI Desktop it works fine without any error. 

 

1. Power BI Desktop: 

I select a month from dimension table, where there is no referrring data in fact table. Result: Matrix visual shows no value (as expected). 

adamriese_SE_5-1619417374839.png

 

2. Power BI Service: 

I filter the same month as I did in Power BI Desktop where I should have no value but the matrix visual keeps values of the previous filtered state, implying that there is data available for 2020.12 even though the matrix should be empty. 

adamriese_SE_4-1619417316437.png

 

The issue occurs on several browsers. 

Status: New
Comments
v-chuncz-msft
Community Support

@adamriese_SE 

 

I tried the latest version to create a report and it seems to work fine for me. Try to clear cache and republish the report.

adamriese_SE
Regular Visitor

@v-chuncz-msft 

 

Thanks for your reply. I am using the latest version of Power BI Desktop, have republished an cleared the cache. Unfortunately nothing has changend. 
The error occurs only in the matrix visual. When displaying the same data with a bar chart, the filter works properly (see screenshot): 

adamriese_SE_0-1619514674198.png