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) separated by a ' / '

It's easily done in excel, but can it be replicated in Power BI? 
Thanks.

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

     

2 Replies

  • sivapandi's avatar
    sivapandi
    Helper I
    7 years ago
    Table =
ADDCOLUMNS (
    SUMMARIZE ( 'KPI', 'KPI'[Detailed] ),
    "APR", CALCULATE ( MAX ( 'KPI'[Realised] ), 'KPI'[Month] = "APR" ) & "/"
        & CALCULATE ( MAX ( 'KPI'[Goal] ), 'KPI'[Month] = "APR" ),
    "MAY", CALCULATE ( MAX ( 'KPI'[Realised] ), 'KPI'[Month] = "MAY" ) & "/"
        & CALCULATE ( MAX ( 'KPI'[Goal] ), 'KPI'[Month] = "MAY" ),
    "JUN", CALCULATE ( MAX ( 'KPI'[Realised] ), 'KPI'[Month] = "JUN" ) & "/"
        & CALCULATE ( MAX ( 'KPI'[Goal] ), 'KPI'[Month] = "JUN" )
)

     

     

    hI.,

     

    I used above dax code to create temp table as u want. hope will solve your issue.i got the result as attached image.

  • 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