Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Display the current selection line-by-line inside a card

I wrote a measure to display the current selections( From various slicers ) in a card.
I want the current selected values line byline. i.e; If I select "male" from "gender" slicer ,it must be displayed in the first line inside the card.Similarly, when I further select "21+" value  from "Age" slicer, I need to get that selection in next line after the "Male". 
The problem is that , I am getting the current selected values in a straight line which exceeds the card size.

Should I write any measure for the values to be displayed in vertical order line by line?? or is ther any other option to display all the selected values inside the card ( in vertical line- one after one)

Thank you

3 Replies

  • sturlaws's avatar
    sturlaws
    Icon for Resident Rockstar rankResident Rockstar

    Hi Anonymous ,

     

    you could try to use UNICHAR(10) where you want your line breaks, eg. "string1" & UNICHAR(10) & "string2"

     

    Cheers,
    Sturla

    If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

    • Anonymous's avatar
      Anonymous
      Not applicable

      HI Sturla,
      I tried that method,but couldn't get the desired output as mentioned in the question.
      Please suggest any other mothed if possible & Available.
      Thanks for your efforts

       

      Regards,
      Vignesh 

      • sturlaws's avatar
        sturlaws
        Icon for Resident Rockstar rankResident Rockstar

        It would be helpfull if you included a sample report with which demonstrates what's not working.

         

        I got this code to work:

        Measure =
        SELECTEDVALUE ( 'Table'[age] ) & UNICHAR ( 10 )
            & SELECTEDVALUE ( 'Table'[Employment] )
            & UNICHAR ( 10 )
            & SELECTEDVALUE ( 'Table'[gender] )

        but I might have misunderstood what you are trying to do