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...
  • 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