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.
I am aware of the merge options available in power bi while importing the data but want to check, Did any one merge the cells in the table chart ? I have requirement to merge the cells if the values present in the same column are same.
Thanks,
Ganesan k.
What do you mean by Merge of cells? Can you explan with sample data?
Thanks
Raj
Hi Rajendran,
Say for example if i get source in the below format
Source | |||
Name | Units1 | Units2 | Units 3 |
Raj | 10 | 30 | 50 |
Raj | 11 | 31 | 51 |
Raj | 12 | 32 | 52 |
I want the output to be like below.
Name | Units1 | Units2 | Units 3 |
Raj | 10 | 30 | 50 |
11 | 31 | 51 | |
12 | 32 | 52 |
Thanks,
Ganesan k.
11, 12 are Units, but why do you want to display under Name column? Its misleading?
I have just provided name as example. You can consider any text column present in the first column and it has be merged like how do we do in excel file. Is it possible?
Thanks,
Ganesan k.
Not as per my knowledge. But lets see if we get any other response.
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |