Show Items With No data Not Working

[jdobrzen]

The source of the data is a SSAS Tabular model.

In Power BI Desktop I have the "Show Items with no data" option checked and I get the following x-axis. I see several dates to the right with no data, which is what I want to see.

 

When I deploy the report to the Power BI Service, the "Show Items with no data" is still checked, but as you can see the dates with no data are not shown.

[Anonymous]

@jdobrzen,

I am not able to reproduce this issue in my environment. Do you apply any filters to your report? Also how about you directly connect to SSAS in Power BI Service and create the report?

Regards,
Lydia

[jdobrzen]

@Anonymous There are other report level filters applied. When I apply them to a report build directly in the service using the dataset connected to SSAS, it gives me the same result. I am not shown the day's without data.

However, those same filter are applied in Power BI Desktop and I am able to see the days without data?

[Anonymous]

@jdobrzen,

This issue has been reported internally: CRI 58650675. Will update here once I get any information. 

Regards,
Lydia

[jdobrzen]

@Anonymous  Does that mean you were able to re-create the issue?

Thank you again for investigating!

[Anonymous · Accepted solution]

@jdobrzen,

Do you have bidirectional crossfiltering enabled for any relationships in the data model? What used to happen prior to January 2018 was that columns that had Show Items With No Data enabled would not respect bidirectional crossfiltering, and in this case, visual shows N values for the column with Show Items With No Data in Desktop, after publishing the report to the Power BI Service, that column shows less than N values.

However, in February update of Power BI Desktop, visual shows less than N values for the column with Show Items With No Data, which is consistent with Power BI Service.  And this behavior is actually the correct one.

If you prefer the old behavior of not having the filters impact the Show Items With No Data columns you can disable bidirectional crossfiltering in the data model.

Regards,
Lydia