Forum Discussion
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...
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.
| Date | Item Name | Qty |
| 21-01-2020 | Test1 | 2.00 |
| 23-01-2020 | Test1 | 2.00 |
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?
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
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