Dynamic Title based on quarter selection

[scuderia]

Hello BI Community

I have a slicer where users have the possibility to filter data based on quarter figures, so for e.g. in 2020 "Q1/20" up to "Q4/20" can be choosen individually or all together.

So the Title within the report should therefore indicate which filter has been set with the following layout:

Q1/20 up to Q4/20                                                  => "Q1/20 - Q4/20"

Q1/20, Q2/20 and Q4/20 (no Filter  on "Q3/20")    => "Q1/20 - Q2/20 | Q4/20"

Any help would be greatly appreciated!

[ERD]

Hello @scuderia ,

For the first formatting option you can use something like this:

Title = 
IF(
    ISFILTERED(QY),
    IF(
        COUNTROWS(ALLSELECTED(QY[Q])) = COUNTROWS(ALL(QY)),
        COMBINEVALUES("-",MIN(QY[Q]),MAX(QY[Q])),
        "Data for " & CONCATENATEX(ALLSELECTED(QY[Q]), QY[Q], ",")
    ),
    "Data"
)

The second formatting option looks interesting, but quite complicated. You need to somehow cut the resulting string into pieces defining when values go not one by one. 

Here is a nice video for other dynamic title options: Multi-select Dynamic Titles in Power BI Desktop 

[amitchandak]

@scuderia ,

Not very clear

you can create a measure like

concatenatex(Table, Table[Qtr], "-")

and use that in title

[scuderia]

Thank you amitchandak for your input but I'm looking for a smarter solution where both requested formats are shown.

[amitchandak]

@scuderia , can share data input and output data in table format.