How to get selectedvalue output from Report Page into DAX Data Table
Hello PowerBI Community, I have hit a major roadblock while developing dynamic column reference for matrix visual. Below is the summary: INPUT Table (this is already loaded in DAX Data): EXPECTED Output Table : (This is matrix visual on report page) Current method which I'm trying: Made separate table which has column headers & put that as slicer with single selection, then used "selectedvalue" to take the bucket that should go in Column of matrix visual. But, Power BI is not allowing to insert measure in matrix column (only allows in values) The alternate solution which I tried: We want to put selected value of slicer in DAX Data Table so that we can create calculated column referring to bucket which user wants like below. But, "selectedvalue" dax is returning only blank values in Data Table. Expected output is like below so that I can drag this colum in "Column Field" of matrix visual. So, in a nutshell, two issues : i. Not able to add measure in column field of mattrix visual ii. Not able to pull "selectedvalue" from report page in data table Will really appreciate help from the community as this is the key page on the report & I'm stuck with this issue...
