Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

From Excel to Power BI

I want to do the similar or same thing from Excel to Power BI, but am struggling with it. In Excel, there are 2 filters, which it intelligently combines the PARAMETER with the YEAR.   PAR...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Fantastic, this is what I am looking for, Thanks a million.. Power BI has lots of features, and I am learning all from the basic.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    You are welcome.  "Unpivot Other columns" changes thw wide dataset to a long one.

    Please mark my original rely as Answer.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    On the Format icon in the visualisation pane, there is an option to switch the orientation to horizontal.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    It is always recommended to create a Calendar Table.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Fantastic, this is what I am looking for, Thanks a million.. Power BI has lots of features, and I am learning all from the basic.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

You are welcome.  If my reply helped, please mark that as Answer.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    do you mind show me the Steps from the original data (wide) to what you have (long)?

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      4 years ago

      Hi,

      Please review all the steps shown in the Applied steps section of the Query Editor.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        fantastic...you are great. Do you mind explain the step on Unpivoted Other Columns?.. I think it is something like changing from wide to long...