can't create correct X axis

[Anonymous]

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

[v-joesh-msft · Accepted solution]

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.

[SteveCampbell]

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-f588221...

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!

Stay up to date on  
Read my blogs on  

[kentyler]

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  |  Amount

as its fields

[Anonymous]

Hi, thanks for reply! This is the actual data, I just changed division names to dummies, etc. Basically in each division there are multiple domains and for each domain in each division we need to perform multiple steps => the values are dates when these steps are set to.

[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

[kentyler]

so you are looking for something like this

Division	Domains	Date	Step
A	Finance
A	HR	10.09.2019	1
A	IS	10.09.2019	1
A	Sales	10.09.2019
B	Finance	10.09.2019	1
B	Sales	10.09.2019
C	Finance	10.09.2019	1
A	HR	15.09.2019	2
A	IS	16.09.2019	2
B	Finance	16.09.2019	2
C	Finance	20.10.2019	2
A	HR	21.09.2019	3
A	IS	21.09.2019	3
B	Finance	23.09.2019	3
A	HR	0	4
A	IS	23.09.2019	4
B	Finance	01.10.2019	4
A	HR	07.10.2019	5
A	IS	10.10.2019	5
B	Finance	20.10.2019	5

if all you have is the spreadsheet you could possibly write a macro to convert it... but it would be better in the long run to speak to who ever is entering the data