Forum Discussion

Rathai's avatar
Rathai
New Member
1 year ago
Solved

undefined

Hi, I have slicer with period type - monthly, quarterly and weekly. In another slicer(time period) based on the period selection i need to show display data. For mothly/weekly  - monthname - year  ...
  • v-hjannapu's avatar
    1 year ago

    Hi Rathai,

    Thank you  for reaching out to the Microsoft fabric community forum.

    You're using a slicer to switch between Monthly, Weekly, and Quarterly views using field parameters that part is working well. But the issue is, when someone selects a month like Apr-2025 and then switches to Quarterly view, it doesn't automatically highlight the matching quarter Q2-2025. Instead, it resets or shows something else.

    This is actually expected in Power BI because when we switch fields using a field parameter, slicer selections don’t carry over  it resets every time the field changes.

    To handle this smoothly, here’s a workaround you can try:
    Keep your current view toggle as it is.Create a new custom column (like a unified period column) that shows Month-Year or Quarter-Year depending on the selected view.Use that column in a separate slicer and hide it if needed.If you want to go one step further, you can create a small mapping table that connects months and quarters, so Power BI can switch between them smoothly.

     If this answer was helpful, please consider marking it as Accepted Solution and giving a Kudos, it helps the community.
    Regards,
    Harshitha.

  • v-hjannapu's avatar
    v-hjannapu
    1 year ago

    Hi Rathai,

    Just wanted to check if you had the opportunity to review the suggestion provided?

    If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

     

    Regards,

    Harshitha.