Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Merge cells on Table chart

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.

Tips and Tricks

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    What do you mean by Merge of cells? Can you explan with sample data?

     

    Thanks

    Raj

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Rajendran, 

       

      Say for example if i get source in the below format 

       

      Source   
      NameUnits1Units2 Units 3
      Raj103050
      Raj113151
      Raj123252

       

      I want the output to be like  below. 

       

      NameUnits1Units2 Units 3
      Raj103050
      113151
      123252

       

      Thanks,

      Ganesan k.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        11, 12 are Units, but why do you want to display under Name column? Its misleading?