Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
i have a table in which i have a column named areacoaches need to make a slicer that has a single value (by network) which contains a areacoaches column
Solved! Go to Solution.
Hi @Anonymous ,
Do you want to create a slicer with only value with full data from areacoaches column? We need to combine all data from areacoaches column to one by creating a new table. We couldn't add a measure into slicer.
What does "by network" mean?
I build a sample to have a test.
Build a calculated table by this code:
Table 2 = SUMMARIZE('Table',"Full data", CONCATENATEX('Table','Table'[areacoaches]," "))
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Do you want to create a slicer with only value with full data from areacoaches column? We need to combine all data from areacoaches column to one by creating a new table. We couldn't add a measure into slicer.
What does "by network" mean?
I build a sample to have a test.
Build a calculated table by this code:
Table 2 = SUMMARIZE('Table',"Full data", CONCATENATEX('Table','Table'[areacoaches]," "))
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I don't understand what you're asking. You may want to clarify your question by editing it.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 21 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 20 | |
| 13 | |
| 12 |