Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sub-category columns Excel

Hi All,

 

I am trying to create a report from an excel file but my file data is set-up such that the column has a sub category. e.g

 

I have this as an excel format, how do I subcategorize the column in PowerBI?

 

Many thanks,

 

General Comment
Need Help
Show and Tell

9 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi,

       

      Thank you! This is very helpful. Just not sure if how this will work on extremely massive data set.

       

      Many thanks,

       

      Matt

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        Hi,

         

        You are welcome.  Please try it and let me know how it works.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi HotChili,

       

      I want my data to be something drillable in the columns section. So basically drill per country and then per city.

       

      Many thanks,

       

      Matt

      • HotChilli's avatar
        HotChilli
        Community Champion
        7 years ago

        OK, I would like you to be more specific please.  Draw a picture or show me a tabular version of what your data should look like before it gets put into a visualisation