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
dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
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

rjs2's avatar
rjs2
Icon for Resolver I rankResolver I
4 years ago

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's avatar
    dedelman_clng
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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

    • 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**),
  ""
)
      • dedelman_clng's avatar
        dedelman_clng
        Icon for Community Champion rankCommunity Champion
        4 years ago

        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

    • rjs2's avatar
      rjs2
      Icon for Resolver I rankResolver I
      4 years ago

      this gives me all values in the slicer, not just the ones selected

      • dedelman_clng's avatar
        dedelman_clng
        Icon for Community Champion rankCommunity Champion
        4 years ago

        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's avatar
      Raja10ram
      Icon for Helper I rankHelper I
      4 years ago

      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)