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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
AlexS2023
Helper I
Helper I

"Show items with no data" breaks the date slicer!?

Hi all,

 

I have a matrix showing what day employees are assigned to work. I found that this was only showing dates where data existed, so, in order to see weekends, bank holidays etc, I checked the "Show items with no data" option (on the date column), and now it shows all dates. Great. except one thing...

 

Now my date-slicer has stopped working. It doesn't matter if I set it to this year, last year, next 2 weeks etc, the matrix will only show the first 3 months from the first record in my data table (see below) I can't move it at all. The slicer works as normal if i turn off "Show items with no data", so maybe I'm not understanding it correctly. Is this normal behaviour?

  scrnsht.jpg

 

Is there a way to achieve what I want? That is: to show all dates, whether there's data or not, but only within a range specified on a slicer?

 

Many thanks 🙂

AS

2 REPLIES 2
AlexS2023
Helper I
Helper I

Thanks but that didn't help. I've attached a stripped back example to demonstrate the problem.

I think you have succesfully replicated the issue, because you can see in your example the dates of 5th and 7th January, but the 6th is missing. If you just extend the date range to a couple of months you will see that the 'show items with no data' option will show you the 6th, but takes away the slicer's ability to function correctly.

(hopefully this link works!) -> https://drive.google.com/file/d/1a8V9NbKyfZmal8uOJz8RlvJFYXpFy9LQ/view?usp=sharing

Any ideas? TIA 🙂


Screenshot 2.jpg
*If you move the date range, it will exclude data but the columns remain unchanged. PBI Desktop Version: 2.124.2028.0 64-bit 

v-yiruan-msft
Community Support
Community Support

Hi @AlexS2023 ,

Thanks for reaching out to us with your problem. Base on your description, it seems that the slicer will not work when you apply the feature "Show items with no data". I can't reproduce your problem, please find details in below screenshot.

vyiruanmsft_1-1706087219093.png

And for the blank values, you can refer the solutions in the following threads and check if they can be used as workaround.

1.+0

Solved: Matrix Visual - Show Blank Values as Zero - Microsoft Fabric Community

Measure 7 = SUM(marix[amoaunt])+0

2. Create a separated dimension table

Solved: Display zero instead of blank in matrix - Microsoft Fabric Community

Solved: Show items with no data - not working when slicers... - Microsoft Fabric Community

 

In order to get a better understanding on your problem and give you a suitable solution, could you please provide some raw data in your tables (exclude sensitive data) with Text format and your visual settings. It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

 

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.