Forum Discussion
Display slicer values selected in card
Hello, My report has two pages: Intro and Data. This report is exported to Power Point and sent to the customer, so for aesthetic purposes the slicers on the Data page are hidden (collapsible p...
You should be able to create a measure along the lines of
IF ( HASONEVALUE (**slicer field**), SELECTEDVALUE (**slicer field**), "" )
Put that measure in the card and it should be empty when no slicer is selected, and populated when one is.
Hope this helps
David
- For that you should be able to write a measure like
MIN(**Date Field**) && “-“ && MAX(**Date Field**)
That will give you a string to put in a card.
Hope that helps
David
dedelman_clng
Community Champion
Community Championrjs2 - you should be able to use CONCATENATEX for this use case. Something along the lines of
CONCATENATEX(ALLSELECTED(**slicer field**), **slicer field**, **delimeter**)
Hope this helps
David
rjs2
Resolver I
Resolver Ithis gives me all values in the slicer, not just the ones selected
- dedelman_clng
rjs2 - please create a new thread. You will likely need to share a copy of your pbix, your model, data, etc in order to debug your specific use case.
See this post How-to-Get-Your-Question-Answered-Quickly for examples of how you should request for assistance.
Thanks,
David