Forum Discussion

scuderia's avatar
scuderia
Frequent Visitor
5 years ago

Dynamic Title based on quarter selection

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!

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    scuderia ,

    Not very clear

    you can create a measure like

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

     

    and use that in title

    • scuderia's avatar
      scuderia
      Frequent Visitor
      5 years ago

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

  • ERD's avatar
    ERD
    Icon for Community Champion rankCommunity Champion
    5 years ago

    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