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.

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
Super User
Super User

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


@ 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!:
The Definitive Guide to Power Query (M)

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.

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?

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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