Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

need help

Hi All,

         Need your help on the below.i need to show the selected slicers/filters values in the text box as shown in the below.        

 

With Selected value function i could able to show for 2 slicers values  but when i started adding third slicer value to the text with measure remaining values are getting filtered.its happening when i used the filters as well.could someone please let me know how to get all the slicers/filter values selected in the text boxc

 

Regards

Anitha.

 

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , If you do want slicer to interact, You can stop interactions 

    How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4

     

    To Display all values you can use concatenateX function

     

    A Measure like (keep on adding columns)

    concatenateX(allselected(Table[Col1]), [Col1] ," , ")  & " -- " &  concatenateX(allselected(Table[Col2]), [Col2] ," , ") 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Amit,

                   Thank you so much for your quick response. silcers/filters needs to filter the data and at the same time what we are selecting in the slicers/filters needs to be displayed in the text as well so that i know what i have selected. i tried concate but its not working some how.

       

      Regards

      Anitha

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Amit,

                     also iam using the columns for Slicers from different Tables they are not from same table.

      So could you please guide here.

       

      Regards

      Anitha

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    Hi, Anonymous ;

     

     please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    Hi, Anonymous ;

    Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.