Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
The April 2019 dynamic chart title update works great, but when I have "All" in my filter locations selected it does not display them. It only displays the name when I have it filtered. Can I get it to display them all at once?
I have a line chart that shows net migration for 3 states. When I select all 3 of my states I want it to say:
"Net Migration for Montana, Washington, California"
But when I only select Montana, for example, obviously I'd like it to just say "Net Migration for Montana".
Thanks.
Solved! Go to Solution.
This is certainly possible if you create an appropriate measure for the title.
Title Measure = "Net Migration for " & CONCATENATEX ( VALUES ( YourTable[State] ), YourTable[State], ", " )
A measure like this should display all States regardless of how many are filtered or whether all are selected.
Regards,
Owen
Yes, the order can be controlled by adding a 4th argument toCONCATENATEX.
See https://dax.guide/concatenatex/ for full explanation
Title Measure = "Net Migration for " & CONCATENATEX ( VALUES ( YourTable[State] ), YourTable[State], ", ", YourTable[State] )
Something like this should work:
Title Measure = "Starts For " & IF ( ISFILTERED ( 'All Data'[Developer] ), CONCATENATEX ( VALUES ( 'All Data'[Developer] ), 'All Data'[Developer], ", ", 'All Data'[Developer] ), "All" )
Alternatively, you could test whether there are fewer than a certain number of filtered Developers, and display "Multiple" if more than that number are filtered:
Title Measure = VAR Threshold = 10 RETURN "Starts For " & IF ( ISFILTERED ( 'All Data'[Developer] ), IF ( DISTINCTCOUNT ( 'All Data'[Developer] ) <= Threshold, CONCATENATEX ( VALUES ( 'All Data'[Developer] ), 'All Data'[Developer], ", ", 'All Data'[Developer] ), "Multiple" ), "All" )
Regards,
Owen
This is certainly possible if you create an appropriate measure for the title.
Title Measure = "Net Migration for " & CONCATENATEX ( VALUES ( YourTable[State] ), YourTable[State], ", " )
A measure like this should display all States regardless of how many are filtered or whether all are selected.
Regards,
Owen
Hi @OwenAuger,
I have another chart that is filtered by almost 50 Developers. Obviously cannot display all their names in a chart. When I have no filter selected (eg. "Developer - All"), how can I get the chart to display a dynamic title that says "Starts For All"?
Here's my current measure:
Something like this should work:
Title Measure = "Starts For " & IF ( ISFILTERED ( 'All Data'[Developer] ), CONCATENATEX ( VALUES ( 'All Data'[Developer] ), 'All Data'[Developer], ", ", 'All Data'[Developer] ), "All" )
Alternatively, you could test whether there are fewer than a certain number of filtered Developers, and display "Multiple" if more than that number are filtered:
Title Measure = VAR Threshold = 10 RETURN "Starts For " & IF ( ISFILTERED ( 'All Data'[Developer] ), IF ( DISTINCTCOUNT ( 'All Data'[Developer] ) <= Threshold, CONCATENATEX ( VALUES ( 'All Data'[Developer] ), 'All Data'[Developer], ", ", 'All Data'[Developer] ), "Multiple" ), "All" )
Regards,
Owen
Thank you. Is there anyway to list them in alphabetical order? The title order is different than the chart's Legend order and it looks funny.
Yes, the order can be controlled by adding a 4th argument toCONCATENATEX.
See https://dax.guide/concatenatex/ for full explanation
Title Measure = "Net Migration for " & CONCATENATEX ( VALUES ( YourTable[State] ), YourTable[State], ", ", YourTable[State] )
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
104 | |
103 | |
87 | |
61 |
User | Count |
---|---|
168 | |
138 | |
134 | |
102 | |
86 |