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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Pratik078
Frequent Visitor

Slicer date return value BLank

Created a date slicer, after that, the date range select from 010120 to 050120.

Total Quantity of the item is only one date, the Par value of 020120 is just performing a blank show.

How it resolved ?  data show should be blank , 

But at 020220 Quantity is there but the show is not happening with date slicer

7 REPLIES 7
Greg_Deckler
Community Champion
Community Champion

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
amitchandak
Super User
Super User

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Can you share sample data and sample output.

Appreciate your Kudos.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

DateItem NameQty
21-01-2020Test12.00
23-01-2020Test12.00

@Pratik078 

If you are using the Last one month as a slicer and trying find 2019 unless is it using time intelligence or all in filters. It will be blank?

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Test1 Table 2020 data And Test2 2019  test 2 query edit GETDATE () -366 then data will be show till date of previous year. But data show is blank

I will create Calendar Date Slicer and relationship Many to One Date Table To Test1 Table And other Table Test2 Relationship Many to One. 

The Slicer seleted date range 20-01-2020 to 25-01-2020 BUt data show Blank

pb1.jpgpb2.jpgpb3.jpg

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.