Forum Discussion

amyamelyn's avatar
amyamelyn
Regular Visitor
6 years ago
Solved

Showing data from excel as typed in table function

Hi all,
 
I can't seem to make the table in Power BI display in the way it is typed in my excel, instead, it will end up being jumbled up.
 
For example Process Cooling Water Pumps- Plant 1 consists of 5 cables as listed below and so on. I want them to be represented as typed in the excel file in its own "groups". (with the headings if possible)
 
Is there any way I can "lock" the first column? Or how should I approach this?
 

Any help is very much appreciated.

 

  • amyamelyn's avatar
    amyamelyn
    6 years ago

    Hi all,

     

    Thanks all you for your help. 

    I managed to solve the issue by adding another column with a serial number and sorting the data based on that.

    Wish I thought of that earlier! 😅

     

     

6 Replies

  • amyamelyn's avatar
    amyamelyn
    Regular Visitor
    6 years ago

    Hi all,

     

    Thanks all you for your help. 

    I managed to solve the issue by adding another column with a serial number and sorting the data based on that.

    Wish I thought of that earlier! 😅

     

     

    • v-yingjl's avatar
      v-yingjl
      Community Support
      6 years ago

      Hi amyamelyn ,

      Glad to hear the issue is solved. You can accept your reply as solution, that way, other community members could easily find the answer when they get same issues.


      Best Regards,
      Yingjie Li

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi amyamelyn ,

     

    Rather than creating a table visual, try creating a matrix visual in Power BI.

     

    Thanks,

    Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI amyamelyn 

     

    "Is there any way I can "lock" the first column"

    Ans is No, its possible only in Excel.

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi amyamelyn ,

    I'm afraid not. Currently table visual does not support hierarchical level in power bi. Although matrix visual can use hierarchical level, it will show the aggregated value of each field instead of single value, duplicate value in one field will only show once.

     

    Perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas
    It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.