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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

**BUG** Show Items with no data in slicer not working

On a PBI desktop report we have 2 slicers and 1 chart:

Visual 1 is a slicer based on the date dimension (date attribute) - Filter applied

Visual 2 is a slicer based on "Team" attribute - "Show items with no data" is enabled

Visual 3 is a chart, showing a "count" based on a secondary relationship with the date dimension with the "Team" on the axis

 

Slicer 2 displays all of the "Teams" despite the applied date filter when the viewing via PBI Desktop

 

When this report is published to our PBI Service, the "Show Items with no data" option does not work, resulting in "Teams" that are displayed in the chart (remember, it is using a count based on a secondary date relationship), not being displayed in Visual 2 (with "Show items with no data" enabled).

 

Is this a bug?

Status: Accepted
Comments
dev_Varun
Regular Visitor

@v-qiuyu-msft, Yes the explanation seems legitimate. I've updated the dataset with bidirectional cross filtering turned off and it worked for me. The "Show Items with no data" seems to work fine now.

 

Thanks,

Varun