Forum Discussion
Solved
Displaying Matrix data with values and columns
I'm struggling with displaying data on my matrix. I like that my first value (Total Hours Worked) is broken apart by the column (Weekday). I only want the second value (First Planned Hours) to show...
RobHess05 Try activating "Show measures on rows" perhaps? You would need to sort your Weekday column by a numeric weekday number column which you would add in Power Query and use the Sort by under Column tools to do the sort. If all else fails, I did invent a kind of nasty way of doing custom matrix hierarchies/columns:
RobHess05 Try activating "Show measures on rows" perhaps? You would need to sort your Weekday column by a numeric weekday number column which you would add in Power Query and use the Sort by under Column tools to do the sort. If all else fails, I did invent a kind of nasty way of doing custom matrix hierarchies/columns: