Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |