Forum Discussion

mb769's avatar
mb769
Icon for Advocate I rankAdvocate I
6 months ago
Solved

Field parameter for type of date selection

Hi Community,

 

In my report, I want to give the user the possibility to select the time period for which the data is shown.

I want this in different levels:

  • Calendar year (e.g. 2024, 2025, 2026)
  • Academic year (e.g. 2024-2025, 2025-2026,)
  • Month (a month in a given year, e.g. February 2025)
  • Custom: the user can use a date slider to choose a range between a FROM and TO date

My DATE table stores all these levels, which columns like 'date', 'month', 'month-year', 'academic year' etc.

Field parameters seemed the best solution to me, but I did not manage to make it work.

The big problem here is: I want the year (calender year and academic year) as a dropdown list, but the custom date as a slider. (Dates in a dropdown list is not user friendly). Using a slider for all levels does not work either, because the academic year and the month are not stored as a date or a number.

 

Does anyone has a suggestion on how to accomplish this?

Need Help

8 Replies

  • Natarajan_M's avatar
    Natarajan_M
    Icon for Super User rankSuper User
    6 months ago

    hi mb769  , Field params only control switching the data not the visual formatting changing from list / drpodown to slider . 

  • JamieHolding's avatar
    JamieHolding
    Icon for Resolver I rankResolver I
    6 months ago

    I would treat each of them in isolation. Year is a number, Academic Year and Month (with year) are ordered text fields. You're right that it needs to have a date to do the relative selection.

    So you could add a dropdown slicer for the first 3, then a between slicer for the last one. 

    • mb769's avatar
      mb769
      Icon for Advocate I rankAdvocate I
      6 months ago

      Yes, but when using different slicer, how to make suren that they do not interfere with one another?
      E.g. when using the "Academic year" slicer, my visuals should not respond to whichever date is selected in the between slicer.

      • JamieHolding's avatar
        JamieHolding
        Icon for Resolver I rankResolver I
        6 months ago

        What would be the between slicer in that scenario?

        Is this not yet an 'Edit Interactions' issue and you don't want slicers to affect other slicers?

  • mb769's avatar
    mb769
    Icon for Advocate I rankAdvocate I
    6 months ago

    Success, based on this Youtube video:
    https://www.youtube.com/watch?v=fKygF7VEJnQ

    I changed the 'date period' table to Field parameters, and added a dropdown list with the field parameters value which is only visible when the 'Date slicer Filter' = 0

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Icon for Community Support rankCommunity Support
    6 months ago

    Hi mb769,

    We are pleased to note that your issue has been resolved. Thank you for sharing your insights and approach in resolving the issue, which will be beneficial to other members of the community. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

    Thank you.