How to get selectedvalue output from Report Page into DAX Data Table

[Anonymous]

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...

[Anonymous]

Dear Amit, Thank you for the swift reply. But, the table is in DAX Model & Not in Power Query editor. This table is a result of DAX calculations. Any suggestions will be highly appreciated.

[amitchandak]

@Anonymous , I think you should unpivot the first table and bring the day bucket in a row. If needed, use split by delimters

Then you should be able to get that using slicer or you can check for field parameters