Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Overlapping Two Matrix Tables

Hi Can we Overlap two Matrix table, As they have the same Name Column, but Actual & Goal columns are by month. I want to hide the Name column in the goal table. Is it possible ? Thanks, panda2...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    There is no option to Overlap two Matrix table as you metioned inPower BI currently.

    Here are two workarounds

    1. create rectangle (Home->Shape)

    fill in with "white" color and with no lines or lines of "white" color.

    Then move this shape on the matrix as below.


    2. add "actual" and "goal" column/measure in the "Value" field.

     

     

    Best Regards

    Maggie

     

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

Hi Anonymous

There is no option to Overlap two Matrix table as you metioned inPower BI currently.

Here are two workarounds

1. create rectangle (Home->Shape)

fill in with "white" color and with no lines or lines of "white" color.

Then move this shape on the matrix as below.


2. add "actual" and "goal" column/measure in the "Value" field.

 

 

Best Regards

Maggie

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    WOW...this is cool !!v-juanli-msft

    Thank you so much!!

     

    panda2018

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-juanli-msft 

    I have a broblem though.

    When I Put the Actual & Goal in the Value area, It shows the sum Amount in all the months.

    The Actuals are correct.

     

     Thanks,

    panda2018

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-juanli-msft 

    I have a broblem though.

    When I Put the Actual & Goal in the Value area, It shows the sum Amount in all the months.

    The Actuals are correct.

     

     Thanks,

    panda2018

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      7 years ago

      Hi Anonymous

      Are the [Actual] and [Goal] columns or measures?

      If they are columns, right-click on the [Actual] and [Goal] columns in the "Value" field, select "don't summarized".

      Or you could create measures such like

      measure=SUM([Goal])

       

      Best Regards

      Maggie