cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
9028194316 Frequent Visitor
Frequent Visitor

Murge and centre option in Power BI , same as excel

I have requirement as in below screenshot.

Can we achieve it in Power BI? We can do it easily in Excel.

Note: Data is dynamic, not staticPower BI Merge Cells.PNG.

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Murge and centre option in Power BI , same as excel

Hi @9028194316,

 

In Power BI, there is no merge cell feature. But you can create a new column:

 

C1New = IF(Table1[C2]=CALCULATE(MIN('Table1'[C2]),ALLEXCEPT(Table1,'Table1'[C1])),Table1[C1],BLANK())

 

Then place this new column and C2 to a table visual. 

 

q4.PNGq5.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Moderator v-qiuyu-msft
Moderator

Re: Murge and centre option in Power BI , same as excel

Hi @9028194316,

 

In Power BI, there is no merge cell feature. But you can create a new column:

 

C1New = IF(Table1[C2]=CALCULATE(MIN('Table1'[C2]),ALLEXCEPT(Table1,'Table1'[C1])),Table1[C1],BLANK())

 

Then place this new column and C2 to a table visual. 

 

q4.PNGq5.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.