Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Custom messages based on slicer selections

Hello, I have the following table and i am using a slicer with a list to select the Document ID and a Card visualization to show the selected Document ID. It works when one Document ID is selected i...
Need Help
  • AUDISU's avatar
    AUDISU
    4 years ago

    Hi Anonymous ,

     

    Can you try this?

    Filter Selected =
    IF (
        CALCULATE (
            HASONEVALUE ( MyTable[Document ID] ),
            ALLSELECTED ( MyTable )
        )
            = TRUE (),
        CONCATENATEX ( VALUES ( MyTable[Document ID] ) , [Document ID] , ",") ,
        "Multiple Document ID's selected"
    )
    Thank you
AUDISU's avatar
AUDISU
Icon for Resolver III rankResolver III
4 years ago

Hi Anonymous ,

Use following DAX with IF function.

Measure =  CONCATENATEX ( VALUES ( MyTable[Document ID] ) , [Document ID] , ",")
Thank you.
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi AUDISU Thank you for your reply! I have tried the measure and it works when one or multiple Document ID's are selected in the slicer list. However, when no Document ID's or "Select all" option is chosen, there is a big list of all the Document IDs. Is it possible to show a custom text message instead? Such as, "All Document ID's selected"?

I have made some progress but i do not know how to change:

1. The value "1" to the currently selected Document ID

2. The value "2" to a text that says "Multiple Document ID's selected".

Is this possible?

Filter Selected = 
IF (
    CALCULATE (
        HASONEVALUE ( MyTable[Document ID] ),
        ALLSELECTED ( MyTable )
    )
        = TRUE (),
    1,
    2
)

 

  • AUDISU's avatar
    AUDISU
    Icon for Resolver III rankResolver III
    4 years ago

    Hi Anonymous ,

     

    Can you try this?

    Filter Selected =
    IF (
        CALCULATE (
            HASONEVALUE ( MyTable[Document ID] ),
            ALLSELECTED ( MyTable )
        )
            = TRUE (),
        CONCATENATEX ( VALUES ( MyTable[Document ID] ) , [Document ID] , ",") ,
        "Multiple Document ID's selected"
    )
    Thank you
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      AUDISU Thanks for the reply! It works. I have also done some research and came up with this alternative working version. I'm not sure if it's correct or if it will give any unforeseen problems?

       

      Filter Selected =
IF (
    CALCULATE (
        HASONEVALUE ( MyTable[Document ID] ),
        ALLSELECTED ( MyTable )
    )
        = TRUE (),
    SELECTEDVALUE ( MyTable[Document ID] ),
    "Multiple Document ID's selected"
)