Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 static.
Solved! Go to Solution.
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.
Best Regards,
Qiuyun Yu
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.
Best Regards,
Qiuyun Yu
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |