Forum Discussion
Helper IVHow to show X Axis Vertically.?
Hi there ,
Is there any way to show the table - Breaches for Last 7 Days
Convert it to like below - X Axis Vertically ? and Values Horizontally ?
If I move the Day Month from Row to columns it look like this -
Thanks
Use the "Show on rows" option in the formatting pane as described here:
https://powerbidocs.com/2020/10/09/show-values-on-rows-for-matrix-visual/This option may be moved around with the new format pane. This is where it is currently in the new pane experience.
4 Replies
- amitchandak
Super User
suvechha , In Matrix visual, Take date column. and Measures in values and enable option Show on row
- AlexisOlson
Use the "Show on rows" option in the formatting pane as described here:
https://powerbidocs.com/2020/10/09/show-values-on-rows-for-matrix-visual/This option may be moved around with the new format pane. This is where it is currently in the new pane experience.
suvechhaThanks its working. But how do the sort by Day Month. There is no option for that.
- AlexisOlson
Hmm. The default sorting should order the columns by that dimension's sort order. I'm not sure you can remove sorting by measure once applied, so you might need to delete and recreate the matrix without manually applying any sorting.
