Display slicer selection of year and quarter in a card

[Anonymous]

I have a slicer with Year and Quarter columns in it. I want a measure to display selected values as Year, Quarter if Quarter is filtered otherwise just display year if all quarters are selected like
2019, Q1, Q2, 2018, 2017

I can display year with below formula:

IF ( ISFILTERED ( 'Reporting Period'[Reporting Year] ),

VAR Applied_Filters = FILTERS ( 'Reporting Period'[Reporting Year] )

VAR Applied_Filters_CSV = CONCATENATEX ( Applied_Filters, 'Reporting Period'[Reporting Year], ", ", 'Reporting Period'[Reporting Year], ASC

)

VAR Applied_Filters_Text = " Reporting year = " & Applied_Filters_CSV

RETURN Applied_Filters_Text

)

But struggling to combine quarter selections with it.

Thank you!

[Anonymous · Accepted solution]

Hi @Anonymous ,

I have built a data sample like this:

Please try:

Measure = 
VAR _count =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Reporting Quarter] ),
        FILTER (
            'Table',
            'Table'[Reporting Year] = MAX ( 'Table'[Reporting Year] )
                && 'Table'[Reporting Quarter] IN ALLSELECTED ( 'Table'[Reporting Quarter] )
        )
    )
RETURN
    IF (
        _count < 4,
        MAX ( 'Table'[Reporting Year] ) & ","
            & CONCATENATEX (
                ALLSELECTED ( 'Table'[Reporting Quarter] ),
                'Table'[Reporting Quarter],
                ",",
                [Reporting Quarter], ASC
            ),
        MAX ( 'Table'[Reporting Year] )
    )

Final Output = 
VAR _T =
 SUMMARIZE ( ALLSELECTED('Table'), 'Table'[Reporting Year], 'Table'[Reporting Quarter] )
VAR _T2 =
 SUMMARIZE (
 _T,
 [Reporting Year],
 "Combine",[Measure]
 )
RETURN
CONCATENATEX ( _T2, [Combine], ",", [Reporting Year], ASC )

The final output is shown below:

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

[Anonymous]

Thank you for the solution. It definitely needed advanced DAX skills to come up with this solution. Thanks a lot!