Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    7 years ago

    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

  • dedelman_clng's avatar
    dedelman_clng
    7 years ago
    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
rjs2's avatar
rjs2
Icon for Resolver I rankResolver I
4 years ago

how would I combine that with this? 

IF (
  HASONEVALUE (**slicer field**),
  SELECTEDVALUE (**slicer field**),
  ""
)
rjs2's avatar
rjs2
Icon for Resolver I rankResolver I
4 years ago
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's avatar
    Raja10ram
    Icon for Helper I rankHelper I
    4 years ago

    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).