Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
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?
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
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |