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