Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

can't create correct X axis

hi All Novice user here... I need to create a project overview with information on which division is where in the progress for each steps for each Domain. Below is my sample data set. I would lik...
Need Help
  • v-joesh-msft's avatar
    v-joesh-msft
    6 years ago

    Hi Anonymous ,

    I think you need to use Unpivoted Columns to meet your needs.

    1. Open the Query Editor in Power Bi, select the column you want to unpivot, select Unpivoted Columns, results are as follows:

    2. Close and Apply, at this time you can create the desired results according to your needs, examples are as follows (you may need to adjust the format of the time before applying the time slicer):

    Here is a demo, please try it：

    https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ETEukiwiFe5Pid3JkisLiTEB2_rVKEJ7JosLGcAuzY1L_Q?e=PysbIO

     

    Best Regards,

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