Count and conditional formatting for power BI matrix and values table

[Saxon10]

I have the following columns are Id, Code, Result1, Result2, Result1 colour code and Result2 colour code in data table.

For Result1 and Resul2 filelds created slicer table for switch the Results with in the same visual for both results (Result1 and Result2)

Data:

1.Expect Result is for Result1-staus with colour code: 

If I select the Result1 column then it will show only Result1 status with colour code.

2.Expect Result is for Result1 Count of status with colour code: 

If I select the Result1 column then it will show only Result1 count of status with colour code.

and the same thing for Result2. 

https://www.dropbox.com/s/71vj7w3jag40pne/Materix%20multiple%20visual%20on%20value%20column.pbix?dl=...

[AlexisOlson]

It seems like you need separate visuals if want entirely different row dimensions in each case. Maybe buttons and bookmarks can do the job.

[Saxon10]

@AlexisOlson,

Thanks for your reply. I never done before the above mentioned option. Can you please advise. 

[AlexisOlson · Accepted solution]

Here's an article to help get you started:

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

[Saxon10]

Thank you so for providing the article.