Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |