Forum Discussion
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
For quarterly - quarter-year
All the columns I have taken from date table
Using field parameter i have achieved the toggle change like mentioned above.
But the client requirement is whatever month they choose then corresponding quarter-year should be selected when they toggle from monthly to quarterly in the time period slicer .
For ex if i select Apr-2025 in monthly and when toggled to quarterly Q2-2025 should be selected dynamically in slicer. In parameter when i toggle it is resetting the selection to default value
Please let me me if there is any possible solution for it
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.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.
5 Replies
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.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 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution so that other community members can find it easily.
Thank you.
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.
