Forum Discussion
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,
panda2018
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
5 Replies
v-juanli-msftCommunity Support
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
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
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