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'm creating a report that my team members can export to PowerPoint and send to their stakeholders. the first page of the report has multiple slicers that impact all pages. This is so my team can show data that is relevant to their audiences only. I want to be able to show those selections on each slide. I could replicate the slicers on each report page but that would just take up too much real estate on each slide. Ideally what i want is a smart footnote that shows all the slicer selections. I thought i could do it with smart narrative but can't figure out how. Any ideas
Solved! Go to Solution.
HI @Johnweet ,
You can try creating a measure using the values concatenated from all the slicer selections. Then display this measure as a footer on your report.
Something like below:
(I have displayed the footer on a multi-card visual as this will always be a single value based on the selections from the slicers)
The measure that I have used is:
Conditional Title =
VAR prodName = VALUES('Supermarket Sales'[Product line])
VAR occur = COUNTROWS(ALL('Supermarket Sales'[Product line])) = COUNTROWS(prodName)
RETURN
IF(
occur, "Summary of Products",
CONCATENATE("Summary of Product Line: ",
CONCATENATEX(
prodName,
'Supermarket Sales'[Product line],
", "
)
)
)
Currently, it takes into account selection from a single slicer, but this can be modified as per requirement to show selections from multiple slicers.
HI @Johnweet ,
You can try creating a measure using the values concatenated from all the slicer selections. Then display this measure as a footer on your report.
Something like below:
(I have displayed the footer on a multi-card visual as this will always be a single value based on the selections from the slicers)
The measure that I have used is:
Conditional Title =
VAR prodName = VALUES('Supermarket Sales'[Product line])
VAR occur = COUNTROWS(ALL('Supermarket Sales'[Product line])) = COUNTROWS(prodName)
RETURN
IF(
occur, "Summary of Products",
CONCATENATE("Summary of Product Line: ",
CONCATENATEX(
prodName,
'Supermarket Sales'[Product line],
", "
)
)
)
Currently, it takes into account selection from a single slicer, but this can be modified as per requirement to show selections from multiple slicers.
Thanks Pragati. I couldn't get your formula to work so started with a Quick measure and created the following.
Hi @Johnweet ,
You will need nested CONCATENATE statements to get multiple selections in the measure.
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 |