Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Visualizing multiple dimension

Hi Folks, I have orders data in which there are individual columns (dimensions) for each status i.e. "Sold-To", "Ship-To", "Credit-Block" the domain value in these columns are "1" (Yes) and "0" (N...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Eric_Zhang if i unpivot these columns then wouldnt data be out of shape ?

I dont see how to attached the file here...there is no option here

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
8 years ago
Anonymous wrote:

Eric_Zhang if i unpivot these columns then wouldnt data be out of shape ?

I dont see how to attached the file here...there is no option here

Anonymous

In my opinion,  the unpivotted data is more normalized, so I'm not getting what you mean "out of shape" here.

As to uploading a pbix file, you can upload it to Onedrive/GoogleDrive and share the download link. Do remember to mask sensitive data before uploading.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Eric_Zhang i cannot share the .pbix i was trying to share the excel raw data with you.. What meant by "Out of shape" was that in the screenshot you shared there were 3 rows and 4 column which when you unpivoted became 9 ROWS and 3 columns. There are other measures and dimensions available in the data set, would that not affect the aggregation of measures ? How can i share the excel raw data file ?

     

    • TomMartens's avatar
      TomMartens
      Super User
      8 years ago

      Hey,

       

      you have to upload your Excel file to onedrive or dropbox and then post the link to this file.

       

      Regards

      Tom

    • Eric_Zhang's avatar
      Eric_Zhang
      Microsoft Employee
      8 years ago
      Anonymous wrote:

      Eric_Zhang i cannot share the .pbix i was trying to share the excel raw data with you.. What meant by "Out of shape" was that in the screenshot you shared there were 3 rows and 4 column which when you unpivoted became 9 ROWS and 3 columns. There are other measures and dimensions available in the data set, would that not affect the aggregation of measures ? How can i share the excel raw data file ?

       

      Anonymous

      Without seeing the whole picture, I don't know how much the unpivoted table is out of shape. In my opinion, the unpivoted data is more normalized and other measures and dimension could also rely on the unpivoted data.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Eric_Zhang here is the link to the file... The data will look a weired because i have change it to mask the original data..

         

        https://1drv.ms/x/s!AmmVLHvv2Mcyaj3PRbe9mWFCCho 

        I also tried to unpivot the columns however it increased the  number of rows e.g. if there were 100 , now  there are 1300 because i unpivoted 13 columns. Also the aggregations in the reports were also increased.