How to show selected values of date hierarchy slicer in card

[lpost]

I have a date hierarchy slicer on one page of my report that is synced to a second page. On the second page, I want to have a card that displays the values selected in the date hierarchy slicer. The slicer has three levels: year, quarter and month using a Policy Effective Date field below:

If a full year level is chosen, I want the card to display the year instead of a breakout of the levels below. For example, the card should display "2019, 2020" for the selection below:

But also keep the year when a certain quarter or month is chosen. The first image below should show "2019 Qtr 1" and the second one should show "2021 January":

   

And be able to combine multiple selections. The below should show "2019, 2020 Qtr 1":

As I'm typing this I realize this may be extremely complicated and why I haven't been able to find any solutions yet. But any help is appreciated!

[v-henryk-mstf · Accepted solution]

Hi @lpost ,

According to your description, you can use the CONCATENATEX function to achieve a similar effect. It calculates the expression for each row of the table, and then concatenates the result into a string, separated by a specified separator.

Take the date hierarchy as an example. If quarter is selected, all dates of day will be selected by default. You must filter manually. If there is no hierarchical structure, then any splicing can be carried out.

1 = CONCATENATEX(VALUES('calendar'[Date]),'calendar'[Date],"-")

So day is selected by default:

no hierarchy:

Hope to help you solve the problem.

Best Regards,
Henry

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

[amitchandak]

@lpost , check if isfiltered can help you to get that

example = if(isfiltered([Date].month), 1, 0)