Forum Discussion

Icon for Helper I rank

Helper I

4 years ago

Solved

Dynamic End date Slicer based on the Filter

Hello All, I am trying to make the end date slicer to be dynamic based on the filter. Please see the screenshot below to get an idea. When I select "Most Recent Final" from the Date Filt...

Samarth_18
4 years ago
nikhil425 Could you please share what would be condition for actuals or you can send it updated file actuals data as well.?

Icon for Community Champion rank

Community Champion

4 years ago

Edit interaction was enable on your visuals thats why it is not filtering. Kindly refer updated file below:-

https://we.tl/t-0rWfmSNrxF

Thanks,

Samarth

nikhil425
Helper I
4 years ago
Thank you Samarth_18

I don't know why the interaction was disabled on my date slicer, Thanks for your input, I have fixed it. However, is it possible to show min date when Preliminary is selected.

For example when Preliminary is selected, the filter shows everything until 12/31/22. However users wanted to see only the actuals (which is less that or equal to 12/31/2021) not forecasted data.

Can we add a logic based on the relative date or any other way just for Preliminary
- Samarth_18
  Community Champion
  4 years ago
  nikhil425 Could you please share what would be condition for actuals or you can send it updated file actuals data as well.?
  - nikhil425
    Helper I
    4 years ago
    Samarth_18 : Please find the pbix file in link below:
    
    https://drive.google.com/file/d/1YuqqbByT_oW3o-k5S3BLPmJ9UakrlSZL/view?usp=sharing
    
    I have modified the logic for the date filter to show Forecast as a drop down value:
    
    Sorry, I think I didn't explain it properly in my previous message, basically when user selects Most Recent Final, then they should see all the data that were final, when they select Preliminary, they would like to see all the preliminary including Final, similarly when Forecast is selected, they should see everything.
    
    I can educate users to Multiselect if they want to see everything, however there are so many users, so I am thinking if there is a way to achieve this without mutiselecting filter values.