Merging 2 cells..

[amtrakrob]

We track the ACTUAL and PLANNED (units) for nuts and bolts (just an example) separately.. But we purchase them under the same cost center. Which means we cannot break out the actual cost for the nuts and the actual cost for the bolts.

What I need is the Budget and Actual box to be merged (?) to show double size next to the units.

Example:

Notes...
1. There are numerous other items above and below the NUTS AND BOLTS on the report.
2. Taking the Budget and Actual, dividing by 2 and showing that as the cost next to each item is not an option. It must be one cost next to both items.

any help is greatly appreciated.

[Anonymous]

Hi @amtrakrob ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Thanks.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @amtrakrob ,

As @amitchandak said, It's not possible currently.

But this is at idea/feedback level alone. May be , hopes Power Bi will implement this in nearby future.

If you also want this in power bi, let the power bi community to know this things and give your votes at power bi site's feedback - https://ideas.powerbi.com/ideas/idea/?ideaid=b03e39a3-78e8-48c7-b2fa-70c5e0ea6ff3

Did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Eyelyn Qin

[amitchandak]

@amtrakrob , merge box is not possible. Only rows(row column)  in merge in Matrix

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual