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
TomMartens
Super User
Super UserHey,
maybe this great "Quick Measure" by Greg_Deckler may be some kind of overload for what you are looking, but there are some gems in it.
Regards,
Tom
Thank you so much, dedelman_clng! That is working perfectly for the card to display the customer selected. Unfortunately it is not working to display what date range (from/to dates) in the date slicer. I suspect it is due the HASONEVALUE and this slicer creates two values. Any idea what tweak would be needed for that?
Thanks again!
Stacey
- dedelman_clng
Community Champion
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