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,
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-hjannapu1 year agoCommunity Support
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.
- v-hjannapu1 year agoCommunity Support
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.- v-hjannapu1 year agoCommunity Support
Hi Rathai ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Harshitha.