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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

**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