Change date hierarchy level displayed in slicer based on selected value in another slicer

[jcscheidl]

Hi all,

I'm having some trouble with slicers and hoping someone here can help -

Context:

I have 2 slicers:

• A date hierarchy slicer that currently displays Year, Quarter, & Month -- able to be selected by users.
• A 'Comparison Scope' slicer where users are able to choose "MoM" (month over month), or "QoQ" (quarter over quarter) to dictate the appropriate timeframe for analysis.

Problem Statement:

I would like for my date hierarchy slicer to allow for selection of the "Month" hierarchy level if the comparison scope slicer is set to "MoM" (year and quarter should still be visible for reference, just not able to be selected).

Conversely, I would like the date hierarcy slicer to only display "Quarters" as selectable if the comparison scope slicer is set to "QoQ" (years should still be visible, but months would not be necessary).

Is this acheivable?

Date Hierarchy Slicer

Comparison Scope Slicer

Thank you!

[v-weiyan1-msft · Accepted solution]

Hi @jcscheidl ,

Based on your description, you want to dynamically change the optional levels in the Date Hierarchy slicer based on another slicer selection. Unfortunately, Power BI doesn't natively support changing the hierarchy levels that are selectable based on slicer inputs, but there is a workaround using bookmarks and buttons.
My Sample:

Please try the following steps:
1. Create two separate slicers with different hierarchical structures, as shown below.

2. Use the Date Hierarchy Slicer to configure the report view of QoQ for selection at the quarterly level. Create a bookmark for this view and name it "QoQ View".
Do the same for the "MoM View".
3. Use the selection pane to hide or show the correct slicer based on the bookmark selected.

4. Add buttons and assign actions to the buttons to activate the corresponding bookmarks.

For more you may refer to:

How to create Bookmark with a Slicer in Power BI - YouTube

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jcscheidl]

Hi @v-weiyan1-msft,

This worked like a charm. Thank you so much for turning me on to this capability! I'm still in the very early stages of learning this tool, so tricks like this are extremely helpful -- hopefully others think so as well!

Cheers,

Jake

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...