Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I know this has already been covered, and probably asked by me before, but I am finding multiple and confusing solutions which i'm not sure are what I need.
I have a date slicer holding month and year of the last twelve months, so report consumers can filter the data.
I want a dynamic title which appears, if they apply this slicer. And shows all the months they have picked.
I can do the measure for if they pick one month, but as soon as they pick two, it breaks.
HELP!
Solved! Go to Solution.
Hi, @Anonymous
Could you tell me whether your problem have been solved?
You can also try measure as below to create dynamic title:
Selected Month =
VAR selectedmonth =
VALUES ( 'financials'[Date].[Month] )
RETURN
"Sales by Month: "
& IF (
COUNTROWS ( selectedmonth ) = COUNTROWS ( ALL ( 'financials'[Date].[Month] ) ),
"All",
CONCATENATEX ( VALUES ( 'financials'[Date].[Month] ), 'financials'[Date].[Month], "," )
)
Please check my sample pbix file for more details.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
Could you tell me whether your problem have been solved?
You can also try measure as below to create dynamic title:
Selected Month =
VAR selectedmonth =
VALUES ( 'financials'[Date].[Month] )
RETURN
"Sales by Month: "
& IF (
COUNTROWS ( selectedmonth ) = COUNTROWS ( ALL ( 'financials'[Date].[Month] ) ),
"All",
CONCATENATEX ( VALUES ( 'financials'[Date].[Month] ), 'financials'[Date].[Month], "," )
)
Please check my sample pbix file for more details.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey @Anonymous ,
can you post your measure?
This makes it easier to help you.
Did you put multiple values together with CONCATENATEX?
Hey @Anonymous ,
I've seen you deleted the reply.
The reason there was that you used the FORMAT function on the already concatenated string.
So if the string looks like "01 20201, 02 2021, 03 2021" and you use the FORMAT function on it, it would not work because the format doesn't fit.
Does this solve your issue?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |