Forum Discussion
Date Slicer
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. 🙂
So do you want to only see data for that specifik date?
Or do you want to only show one date in your slicer, but show all dates in the report upto that date?
yes 1st one want to only see data for that specific date
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 dataHey Khushboobarai
Ok I think I found a better solution.1. You can go to your calender table and add a new column like this
Date 2 = Calender[Date]2. Change the format to Short date3. Change the type to text4. Sort Date 2 by date
Add date 2 in your filter and add the search option.
select the slicer and go to visualization - > options and pick single selecti.
Thank you worked but instead filter min measure to whole page, i did only to the slicer visual of date itself works perfectly fine.