Forum Discussion
Date Slicer
- 9 months ago
This is a bit of a workaround, but it is how I do it myself.
I go to visual and pick after.
Than I reduce the size of the visual so it only shows the top date (even thought both date technily are there.)
You can add a filter in dax that makes sure you filter the entire page to the minimum selected date.
I hope this helps. 🙂
I tried this way too, but this will not allow to choose the previoud date right?
suppose for now you selcted 1-1-2020 the visual will show the data for this date, then you select 30-1-2020 then if yo agin want to go to the previous of 30 jan like 25 or 2 0r 3 then the calendar pop up show those date as diabled,
Also the whole report or the visual wil show after dates as if you slected 01 01 2020 then it will shwo all the data from 01-01 to its max date
but why it can't be specific?
why the power bi doesnt allow only to show 01 jan ka data
Hey Khushboobarai
Ok I think I found a better solution.
1. You can go to your calender table and add a new column like this
Add date 2 in your filter and add the search option.
select the slicer and go to visualization - > options and pick single selecti.
- Khushboobarai9 months agoHelper IV
That will just look like category, which user don't want, they need proper calengdar view to see for the particular date.
Anyway, I did it successfully.
thank you so much for your help too.