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.
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.
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.
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.
@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] ," , ")
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |