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.
With the new April 2019 release, I see that I can make a title using a dax forumal when clicking on conditional formatting. I undertand how to create a title that returns a single item from slicer 1 and then a single item from slicer 2.
The formula for the measure I've been using is:
However, I want to to create a title on my stacked bar chart where I can have the selected college from slicer 1 followed by multiple enrollment terms I have selected for slicer 2. For instnace, within the college of business, I would like to see in the chart title "College of Business for 2018-2019 - Fall I GR Evening, 2018-2019 - Fall II GR Evening, 2018-2019 - Spring I GR Evening, 2018-2019 - Spring II GR Evening". Is there any formula to be able to write this and split up the selected values by a comma?
Solved! Go to Solution.
You could use the function CONCATENATEX, like this:
Rubric View Stacked Bar Chart Title =
SELECTEDVALUE(learning_outcome_reults_rubric_view[college]) &
" for " &
CONCATENATEX(
values('learning_outcome_reults_rubric_view'[enrollment term]),
[enrollment term],
", "
)
Cheers!
Nathan
You could use the function CONCATENATEX, like this:
Rubric View Stacked Bar Chart Title =
SELECTEDVALUE(learning_outcome_reults_rubric_view[college]) &
" for " &
CONCATENATEX(
values('learning_outcome_reults_rubric_view'[enrollment term]),
[enrollment term],
", "
)
Cheers!
Nathan
Thank you @Anonymous! That works perfectly!
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |