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

     

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