Forum Discussion
Capture selected value from multiple slicers on same column
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.
Hey folks!..
My scenario : I have a report page which has 2 slicers which is fetching value from the same table and same column, i have used edit interactions to show 2 chars based on the above to slicer selections.
what i need : I need to get the value selected in each slicers in two different variables inside a measure. I tried using SELECTED VALUE but returns blank always.
could some one give me any ideas...!
Anonymous wrote:
My scenario : I have a report page which has 2 slicers which is fetching value from the same table and same column, i have used edit interactions to show 2 chars based on the above to slicer selections.
Using 2 slicers on the same column will not work. If your slicer was months for example and you selected June and July this sort of configuration would generate a filter which logically says " show me all rows where the month equal June and July" and there will be no rows where this is true resulting in your blank value.
Instead you need to either use 2 different tables in your slicer (one or both could be disconnected and you could then do your filtering in a measure)
OR you would need to use a single slicer and get people to multi-select the 2 items.