Matrix Visual not Displaying Blank Information when Filtering (from Slicer) in Online PBI Service

[SheldonEdwards]

Hi All

There is a bug in the Online Power BI Service where Matrix visuals (both old and new matrix styles) do not display ‘no data’ states correctly when filtering the Matrix using a slicer.

i.e. If the Matrix is filtered so that it contains data, there is no problem. If the slicer filters the Matrix so that it should not contain any a data, the Matrix does not transition to a state showing no data, but continues to show the data from the way the Matrix was previously filtered.

• This issue is only happening on Online Power BI Service, everything is working 100% in the desktop app
• This issue occurs in IE, Edge, Chrome & Firefox.
• This issue occurs with both old and new Matrix visuals

I have published a stripped down/fictionalised version of my original report here:

https://app.powerbi.com/view?r=eyJrIjoiNmFlOTA2ODQtZWNkNy00NGVlLThjYmEtODdjMjg2MjI1N2FmIiwidCI6IjJkM...

As well as provided the PBIX file here:

https://drive.google.com/open?id=0B-TK-K5EDIWNYmtkVllOaEQ3SXc

Please note that the I removed all of the dynamic date DAX formulation so that the visuals will be static and not change as time goes on, in order for referencing to images below to remain fixed.

I have also included pages with both old & new Matrix styles, to show that the issue occurs on both.

With “All” priorities selected in the slicer, all 3 tables display information correctly, and cards above display job count infoWith priority filtered in slicer to “50”, cards above Matrix are now displaying a “(blank)” value which is correct. All 3 Matrices should be displaying no data, but continue to show same data as previous state.With priority filtered in slicer to “85”, we can see that the yellow and green card/matrix visuals are displaying the correct priority 85 info, but the red matrix visual is still showing erroneous data (should be showing no data)If you now page to the next page

And then page back again to the same page

We can now see that once the Matrix visuals have been repainted, the red card/matrix visual is now displaying the correct “no data” information

I have seen this issue reported at least twice elsewhere on these PBI forums, but nothing seems to have been done about it. I am hoping now that I have provided the supporting evidence of this fault, that Microsoft will address this issue a.s.a.p. as people within my organisation are reluctant to use a product that reports erroneous information.

Thanks

[v-haibl-msft]

@SheldonEdwards

This issue has already been reported internally to Power BI Team: CRI 47055581

Engineers are actively working on a fix.

Best Regards,
Herbert

[SheldonEdwards]

Great, thanks for the confirmation Herbert Let's hope they find a solution soon.

FYI, I previously reported that "This issue is only happening on Online Power BI Service, everything is working 100% in the desktop app"

I have subsequently started seeing errors occasionaly in Desktop app, related to this issue e.g.

PBI Desktop Unexpected Error caused by tables unable to display blank info

[v-haibl-msft]

@SheldonEdwards

This issue should has been fixed now based on my test. And I cannot repro the Unexpected Error issue in PBI Desktop. Are you using the latest version of Power BI Desktop?

Best Regards,

Herbert

[SheldonEdwards]

@v-haibl-msft

Hi Herbert

I had another look at my online report I mentioned in my original post and you are correct... it does appear to be working now Awesome

I cant say 100% for sure if the issue I'm seeing in the desktop is definitely related to the issue I originally reported... it appeared to be. If I remember correctly, the error in the error report was "Cannot read property '0' of undefined"... I'm not entirely sure what this means, and dont understand the whole report, so am finding it difficult to pinpoint the problem... but I will try again when it next occurs.

Yes, I am running latest version: 2.50.4859.502 64-bit (September 2017)

Thank 🙂

[xaviermiller]

Hi, I have the same problem : when the filters lead to no data, the matrix result is not empty, but showing all data (or something like that). Using SSAS connection and Power BI Version: 2.50.4859.502 64-bit (september 2017) . Other components like histograms work OK. I have thus an empty histogram and erroneous details in the related matrix.

[Anonymous]

I'm am having this same issue in the June 2018 desktop version of PowerBI.

When I apply slicers that should result in the Matrix showing an empty dataset (because no records meet the criteria) the matrix fails to update to an empy dataset.  Instead the matrix remains static and shows the results of my previous slicers.