The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
Thank you amitchandak for your input but I'm looking for a smarter solution where both requested formats are shown.
User | Count |
---|---|
28 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
33 | |
13 | |
12 | |
9 | |
7 |