merge the cells in Power BI Report view?

[pang22]

Hello,

How to merge the cells in Power BI Report view? Like excel.

After mergred,

[v-jiewu-msft · Accepted solution]

Hi @pang22 ,

If I understand correctly, the issue is that you want to merge the cells in Power BI report. As of the latest updates to Power BI, the feature to merge cells is not available based on my research. You can raise a new idea and add your comments there to make this feature coming sooner. https://ideas.fabric.microsoft.com/ideas/

Best Regards,

Wisdom Wu

[Daniel29195]

@pang22 

i dont think if there is a way of achieveing what you want with the built in visuals. 

maybe you can check some custom visuals ? 

[Daniel29195]

Hello @pang22 ,

im not sure if i understand your question, since power bi  automatically aggregate the data in the visual grouped by the selected dimensions dragged to the visual. 

in your example above, you will see one row, in the visual ( assuming it is a table visual )  : 

2023-PCHQ-0012       sum(AOP Budget)

or is it something else you want to achieve ? 

best regards,

[pang22]

@Daniel29195 Thanks.

Becasue in table visual in Power BI, it will show 5242966.75 in each row when the code is the same.

Is it possible to show 5242966.75 one time in PowerBI table visual like below format?