Overlapping Two Matrix Tables

[Anonymous]

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,

panda2018

[v-juanli-msft · Accepted solution]

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]

@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]

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

[Anonymous]

@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]

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

Thank you so much!!

panda2018