Forum Discussion
Display slicer values selected in card
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
Resolver IHow 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.
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
how would I combine that with this?
IF ( HASONEVALUE (**slicer field**), SELECTEDVALUE (**slicer field**), "" )
- 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
- rjs2ALLSELECTED 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
Raja10ramHelper I
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).
- 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
- 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)