Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
8 years ago
Solved

Date Imported

Hi All,    Hope you have a great day.  I have daily sale report which included around 66 rows of products name and 30 columns of date from 01 to 30. I had imported the data with series of rows a...
Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Chanleakna123,

     

    What is your desired output? Could you illustrate your requirement with an example? Do you want to modify the table structure in data view? Or do you want to achieve a more readable view in report view (visualization) ?

     

    Regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Chanleakna123,

 

The dataset imported into Power BI will keep its original table structure. In your scenario, 66 rows by 30 columns, the same as data source. If you don't like this structure, you'd better change the table format in data source. What we can do in Power BI side is to unpivot date columns so that date values will be plot in row level. Or do some aggregation in some visualizations according to your needs.

 

If I have something misunderstood, please illlustrate your requirement with more detailed information.

 

Regards,
Yuliana Gu

  • Chanleakna123's avatar
    Chanleakna123
    Post Prodigy
    8 years ago

    Hi v-yulgu-msft, 


    Yes , i did unpivot the date to a row , then it will included on 01 Aug 2017 with 66 products Names. Hence, for 30 days will be 66*30. I'm not sure whether everyone did this. 
    Thanks you so much for your response :) 

    Best Regards, 
    Chanleakna Hang 

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      8 years ago

      Hi Chanleakna123,

       

      What is your desired output? Could you illustrate your requirement with an example? Do you want to modify the table structure in data view? Or do you want to achieve a more readable view in report view (visualization) ?

       

      Regards,
      Yuliana Gu

      • Chanleakna123's avatar
        Chanleakna123
        Post Prodigy
        8 years ago

        Hi v-yulgu-msft

        i had unpivoted the columns and rows, these consists a lots of row with what i'm doing now. I think , only this way can works. 

        Your solutions was also help. 

        Thanks you with Best Regards,