Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

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.        

 

AnithaMallampat_0-1658831466045.png

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.

 

5 REPLIES 5
v-yalanwu-msft
Community Support
Community Support

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.

v-yalanwu-msft
Community Support
Community Support

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.

amitchandak
Super User
Super User

@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
Not applicable

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

Anonymous
Not applicable

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors