Forum Discussion
Capture selected value from multiple slicers on same column
- 6 years ago
Oh so you have changed the filter interactivity to block the slicer from affecting the other matrix. In this case you can do this by setting the conditional formatting on the matrix to a measure that uses SELECTEDVALUE.
First create a measure for your title:
Dynamic Title = "Matrix for " & SELECTEDVALUE('Fact'[Account],"Unknown")Then Click on the matrix, go into the title property and hover over the text fields until the "three dots" option appears and then click that to get into the conditional formatting dialog
Then choose the measure you created as the field for the Title text.
Thanks for following up the question.
Kindly find the link for the sample file.
https://1drv.ms/u/s!AuUOyRlH3Y79g5FwcCn5WWhWpJcUJg
Thank you!
Oh so you have changed the filter interactivity to block the slicer from affecting the other matrix. In this case you can do this by setting the conditional formatting on the matrix to a measure that uses SELECTEDVALUE.
First create a measure for your title:
Dynamic Title = "Matrix for " & SELECTEDVALUE('Fact'[Account],"Unknown")
Then Click on the matrix, go into the title property and hover over the text fields until the "three dots" option appears and then click that to get into the conditional formatting dialog
Then choose the measure you created as the field for the Title text.