Forum Discussion
Helper IIIContinuous data from formatted date
Hi, saj
According to your description, it seems that the “Drill down” function in the Power BI can roughly meet your requirement, you can try my steps:
- Right-click on the [Finscial year] column, create a hierarchy for it:
- Right-click on the [Date] column, add it to the Financial year hierarchy:
- Go to the line chart and place the Finscial year hierarchy as the X-Axis of it:
Then you can click on the “Drill down” to see the detailed data under the hierarchy of the Financial year.
Drill mode in a visual in Power BI
You can download my test pbix file below
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi, saj
According to your description, it seems that the “Drill down” function in the Power BI can roughly meet your requirement, you can try my steps:
- Right-click on the [Finscial year] column, create a hierarchy for it:
- Right-click on the [Date] column, add it to the Financial year hierarchy:
- Go to the line chart and place the Finscial year hierarchy as the X-Axis of it:
Then you can click on the “Drill down” to see the detailed data under the hierarchy of the Financial year.
Drill mode in a visual in Power BI
You can download my test pbix file below
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
saj