Selecting single date as calendar on slicer

[swrlabhe]

Hey PBI Gurus,

I have requirement where I have to have Calendar displayed on report andwork as slicer so that If I select a date the data should reflect for on or before that date.

I know the Slider with date range is an option but there is no way to hide start date in that case

I also tried the custom visuals like timeline slicers and other calendar visuals but most of those asks for buying alicense.

Any idea how to hide Start Date in slider so that I camn make it work like single selecting Calendar or any other way to do same?

[v-ssriganesh]

Hello @swrlabhe,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @danextian, @Ashish_Mathur, @Daniel29195 & @MasonMA for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solution? If so, please mark it as the solution. This will help other community members solve similar problems faster.

Thank you.

[danextian]

Hi @swrlabhe 

You can literaly hide the start date by covering it with a shape/textbox and group it together with the date slicer. Ensure that maintain layer order is enabled for both the shape/textbox and the slicer

[swrlabhe]

This worked but now I need the selected date only to appear in the report column of As On Date

[MasonMA]

If your slicer is set to Before a date, Power BI interprets that as "include all dates less than or equal to the selected date", so you can use MAX('Date'[Date]) and it will always return that selected cutoff date.

Selected_As_On_Date = 
MAX('Date'[Date])

[swrlabhe]

Ok got it,  I want same way to filter data like start date and end date but if I select Start Date as 01-Jul-2025 then it should give me data on or before for 01-Jul-2025 and same way of I select End Date then 07-Jul-2025, then it should take off selection from Start Date and then apply End Date selection i.e. on or before for 07-Jul-2025.

[Ashish_Mathur]

Hi,

I have solved a similar problem in the attached files.

Hope this helps.

[Daniel29195]

Hello @swrlabhe

I hope you are doing great today, 

i think this would help you 

Show last 6 months based on user single slicer selection.

this video will show you the implmenation needed to be able to if you select a date, let us say 2025-01-01,  the report will show you all the data before that selected date ( in the video will show you last 6 months but you can tweak the code to suit your need ) 

hope it helps  

[swrlabhe]

Thanks for video but its specifically shows how to restrict date from slicer list, I want a single selection date from calendar as slicer and should woirk as on or before date

[MasonMA]

@swrlabhe 

Use a Shape visual that has the same color as your backgroud to cover the 'Start Date' part 😉

[swrlabhe]

Not sure what do you mean , can you help with details 

[MasonMA · Accepted solution]

Usually date slicer with dropdown list plus a measure would work in your case, but it seems you prefer a slicer with Calendar UI. If in your situation, i'd simply set the Date Slicer to 'Before', disable the slider bar and then use a Shape (without border) to cover/hide Start date. 

[swrlabhe]

Ok got it,  I want same way to filter data like start date and end date but if I select Start Date as 01-Jul-2025 then it should give me data on or before for 01-Jul-2025 and same way of I select End Date then 07-Jul-2025, then it should take off selection from Start Date and then apply End Date selection i.e. on or before for 07-Jul-2025.