Forum Discussion
Helper IIITable Visual in power BI
Put date in columns of matrix visual.
and measures in values
Go to Formatting tab of Matrix visual
Under values you will see the option "show on rows" you should enable this to get the desired output.
Jos13 , I think you need to use show on row. Date on Column.
refer step in
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
Please find the attached file after signature
Community ChampionJos13 - To do that, you would need a disconnected table for your rows.
In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
In your case, create the disconnected table with your row values that you want. You can then use that in your matrix in the Rows area. You would craft a measure to take the MAX('DisconnectedTable'[Column]) and calculate what you want based on that.