Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Slicer with only one value inputs full column

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 

  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.