Table to show two measures same row (one at the top, one at the bottom)

[Anonymous]

Hi Experts

Is it possible to set up a table in BI to show show measure for the same category field as shown in the snippet image...

[MFelix · Accepted solution]

Hi @Anonymous,

You shoud use the Matrix visual and then place your values on rows then if you don't want to show the labels you can always reduce the size of that column to be hidden.

Steps are below:

• Matrix visualization
  • Rows: Region
  • Values: Measure 1 / Measure 2
• Format choose the following options
  • Values -> turn on Show on Rows
  • Row Header -> Turn Off Stepeed layout

Then just format the colour as you want.

Regards,

MFelix

[Anonymous]

Hi Mr Felix. Could you show the label and the measures too?.

[MFelix]

Hi @Anonymous,

Are you talking about the tooltips when you hover on a cell? on the format options search for the Tooltips and turn it on.

You can also create a tooltip page and make it show the value.

Regards,

MFelix

[Anonymous]

Thanks for the excellent feedback