Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |