Forum Discussion
Timeline chart
Hello everyone,
Seeking your kind support to provide the most sutiable chart in Power BI based on my data below.
| Date | 20-Nov 9:00 | 21-Nov 9:00 | 2-Dec 9:00 | 3-Dec 9:00 | 3-Dec 13:00 |
| Status | In progress | Not Submitted | Postponed | In progress | Not Submitted |
| Record Number | 21373 | 48291 | 84920 | 47269 | 84619 |
I need a chart which present the above table as below:
& the tooltip could present the recored number.
Thank you for your support in advane.
Hi, randahmed97 ;
You could transposed table in power query. then use matrix.
1.Transposed Table
2.Promoted Headers
3.Split Column by Delimiter
4.use matrix.
5.set tooltip in page2
6. apply it.
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi, randahmed97 ;
You could transposed table in power query. then use matrix.
1.Transposed Table
2.Promoted Headers
3.Split Column by Delimiter
4.use matrix.
5.set tooltip in page2
6. apply it.
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.