Forum Discussion
undefined
- 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. - 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.
Hi Rathai create a measure like Corresponding Quarter-Year to determine the quarter for the selected month using DAX. While slicers can't automatically update selection values, use this measure to guide the user visually or filter visuals dynamically. Field parameters reset by design, so consider bookmarks or buttons to maintain context during toggling. Add tooltips or indicators to help users identify the corresponding quarter when toggling slicers.