undefined

[Rathai]

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

[v-hjannapu · Accepted solution]

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.

[Akash_Varuna]

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.

[v-hjannapu · Accepted solution]

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 · Accepted solution]

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-hjannapu]

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-hjannapu]

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.