Forum Discussion
scuderia
5 years agoFrequent Visitor
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. S...
ERD
Community Champion
5 years agoHello 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