Forum Discussion

PowerCI's avatar
PowerCI
Frequent Visitor
2 years ago
Solved

How to enable users to move rows from on table visual to another.

I have a table of site locations with some columns of data in a visual. I would like the user to be able to click on one location (a single row) and be able to remove it from the table. In other word...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi PowerCI ,
    According to your description, you can use measure in conjunction with slicer and filter to achieve.
    Sample data
    NameValue

    A 30
    B 70
    C 60
    D 90


    Cretae a table

    Slicer Table = VALUES('Table'[Name])


    Create a measure

    IsInSlicerTable = 
IF(
    SELECTEDVALUE('Table'[Name]) IN VALUES('Slicer Table'[Name]),
    1,
    0
)

    Apply the measure to slicer


    Final output

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PowerCI ,
According to your description, you can use measure in conjunction with slicer and filter to achieve.
Sample data
NameValue

A 30
B 70
C 60
D 90


Cretae a table

Slicer Table = VALUES('Table'[Name])


Create a measure

IsInSlicerTable = 
IF(
    SELECTEDVALUE('Table'[Name]) IN VALUES('Slicer Table'[Name]),
    1,
    0
)

Apply the measure to slicer


Final output

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

PowerCI's avatar
PowerCI
Frequent Visitor
2 years ago

Yes this works! Thanks so much. 

 

Only caveat is that if no values are selected in the slicer then the table is blank, which I find a little puzzeling. Not a big problem as I can always keep at least one location selected.