The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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.
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 |
Solved! Go to Solution.
Hi @natalia88 ,
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.
Hi @natalia88 ,
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.
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
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
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
Help when you know. Ask when you don't!
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.
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
Help when you know. Ask when you don't!
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
Help when you know. Ask when you don't!
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
106 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |