Forum Discussion
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 like to be the domains on the Y axis, steps (=columns in my data set) as X axis and the progress bar as values.
- I also need to be able to filter per division - but a scenario with 3 graphs for each division is also fine.
- Perfect would also be a time slicer...
For the life of me I can't figure out how to put the steps (columns) on the X axis. I hope someone can help me!
| Division | Domains | Step 1 | Step 2 | Step 3 | Step 4 | Step 5 |
| A | Finance | |||||
| A | HR | 10.09.2019 | 15.09.2019 | 21.09.2019 | 0 | 07.10.2019 |
| A | IS | 10.09.2019 | 16.09.2019 | 21.09.2019 | 23.09.2019 | 10.10.2019 |
| A | Sales | 10.09.2019 | ||||
| B | Finance | 10.09.2019 | 16.09.2019 | 23.09.2019 | 01.10.2019 | 20.10.2019 |
| B | HR | |||||
| B | IS | |||||
| B | Sales | 10.09.2019 | ||||
| C | Finance | 10.09.2019 | 20.10.2019 | |||
| C | HR | |||||
| C | IS | |||||
| C | Sales |
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：
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.
6 Replies
- kentyler
Solution Sage
Is there data underlying this report... or are you just typing the data into the shape we see here. If there is underlying data what is it like ? Perhaps the answer is to start with the data in a table that has:
Division | Domain | Step | Amountas its fields
- kentyler
I still have the same question.
Can you gather the data in a record format instead of a spreadsheet format.
Who inputs the data ? If they could input the same data as records it would make many more things possible for reporting. If not, then the first task is going to be transforming this data into the record format, maybe in SQL Server or in M
- SteveCampbell
Memorable Member
Think you'll want to look into unpivot in Power Query:
https://support.office.com/en-us/article/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
Highlight Division and Domains, right click, Unpivot Other Columns.Then you'll get a column "Attribute" which can go in the axis
Appreciate your Kudos
Connect with me! 
v-joesh-msftHi 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：
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.
