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.
Hello there
how to capture multi-values from a slicer but; from a multidimensional olap cube?
Anonymous You can use VALUES to return a table with a single column containing multiple rows (which is equal to multiple values)
Maybe you could share more what are you trying to achieve, and some more context for us to simulate!
I'm sending the PBI reports by email in a PDF format. And i'm printing the values of the parameters that we selected in text lines. So when you select multiple values from a filter the value that it is showing is "All" instead the multiple values i selected. The chalenge here is the parameters come from a Multidimensional OLAP cube. So for example the Company filter it is a Dimension from our multidimensional cube.
thanks!