Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Creating a table for daily plan vs. actual data

Hi! I'm working at a manufacturing company and I'm new to Power BI. I'm trying to create a dashboard containing a simple table and need some help.   My raw data in Excel spreadsheet looks like bel...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, Anonymous 

     

    You can try the following methods. Choose Date column then unpivot Other Columns:

    Result:

    Select the second column-Split Column:

    Result:

    Save and apply to Desktop.

    Is this the result you expected?

     

    Best Regards,

    Community Support Team _Charlotte

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, Anonymous 

 

You can try the following methods. Choose Date column then unpivot Other Columns:

Result:

Select the second column-Split Column:

Result:

Save and apply to Desktop.

Is this the result you expected?

 

Best Regards,

Community Support Team _Charlotte

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    Thank you so much, that exactly is what I wanted!  Now I'm trying to reorder the columns by Plan/Actual/Delta but it seems it's not that simple in Matrix. I created another column as index. Plan=1, Actual=2, Delta=3. Then I tried to sort the column using that index but I'm getting an error. Could you shed some light on this?