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.
Good morning.
Is it possible to write a DAX measure for MyTitle as shown below? That is, how do I get the list of values shown in a table and expand them into a concatenated string?
As always, thank you.
Michelle
Solved! Go to Solution.
@michellepace , You can create measure like
concatenatex(Table,[AutoNumber])
and add that to title : https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-format-visual-titles
@michellepace , You can create measure like
concatenatex(Table,[AutoNumber])
and add that to title : https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-format-visual-titles
Hi, @michellepace , you may try a measure like this,
Concat =
CONCATENATEX (
FILTER ( ALL ( tb[AutoNumber] ), tb[AutoNumber] in {69449, 69458} ),
tb[AutoNumber],
UNICHAR ( 10 )
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Only certain numbers you want to display or entire column values want to display. For certain numbers we can implement dax by CNENFRNL suggested. If you want whatever selected from slicer to this column title we will create more dax.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |