The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Is there any way for me to have a textbox that will show what values the user has selected for a slicer? While also dyanmically updating based on their selection?
Solved! Go to Solution.
@bhanes22 Sure, use a Card visual and a measure like CONCATENATEX(DISTINCT('Table'[SlicerColumn]),[SlicerColumn],",")
You can also get really fancy like this: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer...
Hi @bhanes22 ,
As far as I know, it is not possible to use textbox to achieve. You could try card to achieve it.
Try a measure like:
if(isfilterred(Table[name]),selectedvalue(Table[name]),"organization")
Or(more values):
Selected values=
CONCATENATEX ( VALUES ( table[values] ) , [values] , ",")
Since you did not provide the template data, I cannot demonstrate it to you, you can refer to the following links containing similar questions:
https://community.powerbi.com/t5/Desktop/display-text-in-card-based-on-slicer-selection/m-p/1702620
https://community.powerbi.com/t5/Desktop/display-multiple-elements-with-SELECTEDVALUE/m-p/650754
Wish it is helpful for you!
Best Regards
Lucien
Hi @bhanes22 ,
As far as I know, it is not possible to use textbox to achieve. You could try card to achieve it.
Try a measure like:
if(isfilterred(Table[name]),selectedvalue(Table[name]),"organization")
Or(more values):
Selected values=
CONCATENATEX ( VALUES ( table[values] ) , [values] , ",")
Since you did not provide the template data, I cannot demonstrate it to you, you can refer to the following links containing similar questions:
https://community.powerbi.com/t5/Desktop/display-text-in-card-based-on-slicer-selection/m-p/1702620
https://community.powerbi.com/t5/Desktop/display-multiple-elements-with-SELECTEDVALUE/m-p/650754
Wish it is helpful for you!
Best Regards
Lucien
@bhanes22 Sure, use a Card visual and a measure like CONCATENATEX(DISTINCT('Table'[SlicerColumn]),[SlicerColumn],",")
You can also get really fancy like this: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer...