Forum Discussion
can't create correct X axis
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.
Solution SageIs 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
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