Table visualisation

Data Visualizations
1

Hi

I have 3 measures - revenue, cost and margin.

My table visualisation currently shows the following,

image

I’d like the layout to be,

image
image1249×120 3.91 KB

Is there a way to achieve this?

Thanks
Manoj

2

@M_K,

  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:

image

That should do the trick.

  • Brian
1 Like
3

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

4

@M_K,

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