Display slicer values selected in card

[Anonymous]

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 panel).  I would like to add cards to the Intro page which display the values selected in the Customer and Date Range slicers from the Data page.  Can anyone help me with the DAX to create this?

Thank you,

Stacey

[dedelman_clng · Accepted solution]

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

[SarasGupta]

Hi All,

Display slicer values selected in card
But i want it like this.. PLS HELP !!!

If i Select "Jan" in Slicer then result on card would be "Jan"
but if i select "Jan+Feb" then result would be "YTD Feb"
if i select "Jan+Feb+Mar" then result would be "Q1"

[TomMartens]

Hey,

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

[Anonymous]

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 · Accepted solution]

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 · Accepted solution]

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

[rjs2]

How do you display multiple values if multiples are selected?   I am using this for program names and sometimes we want to group programs into one report.

[dedelman_clng]

@rjs2 - 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

[Raja10ram]

Hai dedelman_clng

 Here, I am Used this function and it is working but here the issue is before selecting the values it shows all the values in the card.

I need only the selected Values in the card. otherwise the card should be empty or placeholder like (Customer Name)

[rjs2]

this 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

[rjs2]

how would I combine that with this? 

IF (
  HASONEVALUE (**slicer field**),
  SELECTEDVALUE (**slicer field**),
  ""
)

[rjs2]

ALLSELECTED seems to be pulling all values in slicer regardless if its selected, if I replace the false value with this CONCATENATEX(ALLSELECTED(**slicer field**), **slicer field**, **delimeter**)  -  I want it to combine all values that are selected in the slicer not all values in the slicer

[Raja10ram]

Hai rjs2

 Here, I am Used this function and it is working but here the issue is before selecting the values it shows all the values in the card.

I need only the selected Values in the card. otherwise the card should be empty or placeholder like (Customer Name). 

[dedelman_clng]

Hi @rjs2  - yo uwould not combine it with the previous formula. It would exist by itself.

If you have further issues I would suggest opening a new thread as this one has already been marked solved so most people don't keep up with them.

Hope this helps

David

[Anonymous]

Hey ,
Super user .

Thanks for sharing this details of the Silcer to display.

[lafondm]

This is a great building block, thanks for the paradigm!