Table visualisation


I have 3 measures - revenue, cost and margin.

My table visualisation currently shows the following,


I’d like the layout to be,

Is there a way to achieve this?



  1. Instead of the table visual, switch to the matrix.
  2. Put your month field in the column well
  3. put your your measures in the value well

Then go to the format options for “values” and turn on the show on rows option:


That should do the trick.

  • Brian
1 Like

Awesome, thanks Brian :slight_smile:
I’ve learnt a new trick.


Great – glad that got you what you needed. The “show on rows” option is not that intuitively named IMO. I think it was months before I figured out what that thing did. It is handy once you know what it’s for though…

  • Brian