Need help - Change table visual based on value in slicer

Hi gauravnarchal ,

 

I test two ways to achieve it.

 

1. Add bookmarks. 

 

Referencing: https://www.youtube.com/watch?v=FBEF1xMxxEE 

 

 

2. Unpivot columns.

• Unpivot columns in Power Query Editor.

 

• Create a calculation table.

ClientName = DISTINCT('Table'[ClientName])

• Create the following measures.

Measure = 
IF(
    SELECTEDVALUE(ClientName[ClientName]) = "ABC", 
    COUNTROWS(
        INTERSECT(
            CALCULATETABLE(
                VALUES('Table'[Attribute]),
                FILTER(
                    'Table',
                    'Table'[Attribute] in {"Remark 1", "Remark 2", "Remark 3"}
                )
            ),
            DISTINCT('Table'[Attribute])
        )
    ),
    COUNTROWS(
        INTERSECT(
            CALCULATETABLE(
                VALUES('Table'[Attribute]),
                FILTER(
                    'Table',
                    'Table'[Attribute] in {"Remark 5", "Remark 8", "Remark 9"}
                )
            ),
            DISTINCT('Table'[Attribute])
        )
    )
)

RemarkValue = MAX('Table'[Value])

• Filter the matrix by Measure.

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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