Forum Discussion
Alternatives to Native Line chart?
Any other alternative to better represent/display time based data on a continuous line chart (without joining lines and avoiding misrepresention)?
Hi, cyclist007
Maybe you can copy the date ,then try to change the new column "Text_date" type from "Date" to "Text".
If the axis sorting is not accurate, you may need to create an index column in query editor and make the new column"Text_date" sort by this index column.
You can check if the attached pbix file is helpful.
Best Regards,
Community Support Team _ Eason
v-easonf-msft Thanks for taking the time in creating an example to showcase. But on reviewing it I found that it converts the axis to a categorical axis when the x-axis field is a text field, which does not work well with date-time fields (especially at minute intervals) and also results in misleading gap periods. See below how it ends up looking in below screenshot ... text field/categorical axis does not provide the solution in this case (the huge scroll bar just does not allow for a single view analysis for different lengths of time that the continuous axis allowed for).
Hi， cyclist007
Sorry,I did not find any other custom visual about Line char that meet your requirements .I can't solve it currently.
It is suggest to create a ticket to the support team .Maybe they will have better suggestions.
https://powerbi.microsoft.com/en-us/support/
Best Regards,
Community Support Team _ Eason