Forum Discussion

RuchiK's avatar
RuchiK
Helper I
10 months ago
Solved

Pre-Selected Slicer – Auto Select Current Period & Dropdown Expansion Issue

I am trying to implement a pre-selected slicer for Periods in Power BI. My requirement is to automatically pre-select the current period from my Period table.

  • My Periods are defined in 6-month ranges (e.g., Apr 2025, Oct 2025 , etc.).
  • On 1st October 2025, the slicer should automatically switch from the April 2025 period to the October 2025 period.
  • I am using the PeriodLabel column from my Period table in the slicer.

To achieve this, I tried using a custom “Pre-Selected Slicer” visual, but I am facing two issues:

  1. The pre-selection logic for the current period is not working as expected.
  2. The dropdown expansion behavior of the custom slicer is restricted inside the visual’s border. Unlike the default slicer in Power BI, it does not pop out fully. Because of this, long values are cut off and the user cannot properly see or scroll through the items (see screenshot attached).

My Questions:

  1. Is there a way to adjust the visual settings of the Pre-Selected Slicer so the dropdown expands outside the border (like a normal slicer)?
  2. If not, what are the best alternatives to achieve automatic pre-selection of the current period in Power BI while keeping a user-friendly slicer experience?

Also, I am attaching two one measures I have used for dynamic pre selections :

  1. Selected Period Start =
VAR Sel = SELECTEDVALUE(Periods[PeriodStart], BLANK())
VAR D = TODAY()
VAR Y = YEAR(D)
VAR AprThis = DATE(Y,4,1)
VAR OctThis = DATE(Y,10,1)
VAR CurrentPeriod =
    IF(D >= OctThis, OctThis,
       IF(D >= AprThis, AprThis,
           DATE(Y-1,10,1)
       )
    )
RETURN
COALESCE(Sel, CurrentPeriod)
2.
In Selected Period =
VAR StartDate = [Selected Period Start]
VAR EndDate = EDATE(StartDate, 6)
RETURN
IF(
    MAX('Date'[Date]) >= StartDate && MAX('Date'[Date]) < EndDate,
    1,
    0)

 

 

 

5 Replies

  • 2. Use the Filter Pane instead. It has Relative filter options.

  • v-menakakota's avatar
    v-menakakota
    Community Support

    Hi RuchiK 

    Thanks for reaching out to the Microsoft fabric community forum. 

     

    I would also take a moment to thank  lbendlin , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 

     

    As suggested, you can try using the Filter Pane with relative filters. This way the current period will automatically adjust based on today’s date, without needing a custom slicer.

    Best Regards, 
    Community Support Team  

    • v-menakakota's avatar
      v-menakakota
      Community Support

      Hi  RuchiK ,

      I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

      Best Regards, 
      Community Support Team.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hello RuchiK ,

         

        I am also part of CST Team and we’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

         

        Regards,

        B Manikanteswara Reddy