Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Complex Matrix with multi variables

My goal is to create a table like the one below. The problem is, that each 'cell' should include three elements: 1) & 2 ) a combination of two different variables (Realized and Goal) 3) ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, Anonymous 

    You could get in a matrix visual.

    Realized and Goal are two measure? if so use this formula to create a new measure to combine them together.

    New Measure = [Realized]&"/"&[Goal]
    Then drag it to matrix visual.
    If Realizedand Goal are not two measure, transform them to measure.
     
    Best Regards,
    Lin

     

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

HI, Anonymous 

You could get in a matrix visual.

Realized and Goal are two measure? if so use this formula to create a new measure to combine them together.

New Measure = [Realized]&"/"&[Goal]
Then drag it to matrix visual.
If Realizedand Goal are not two measure, transform them to measure.
 
Best Regards,
Lin