Dynamic Labels for Reports


#1

I would like to show my users what filters / slicers they selected when on a report. I have used the DAX of
Selected Colour = var selectedcolour = SELECTEDVALUE(‘Product’[Colour]) return "Colour: " & IF(ISBLANK(selectedcolour), “All Colours”, selectedcolour).

However, if more than one item is selected then it just defaults to all. Is there a way to show say up to 5 items they have selected before showing them All or more selected?


#2

Easy

Use CONCATENATEX

See below for technique

Lists = CONCATENATEX( VALUES( Customers[Customer Name] ), Customers[Customer Name], ", " )


#3

Thanks @sam.mckay

Is there a way to check that if nothing is selected it puts All Customers?