Line chart x-axis use values in stead of labels

Like (0) Share

Report

Posted on 29 Jul 2020 06:27:51 by HansHeintz

674

I have a collection with dates and weights of an animal and I want to plot an xy chart where the horizontal distance of the points represent there difference in dates. In other words I want an xy chart. How do I achieve this in powerapps? The standard way results in dates as labels, every point equaldistance independent from date.

Categories:

General Questions

All responses (3)

Answers (1)

KCarpenter 2 on 11 Apr 2023 at 18:55:25

Like (0)

Report

Re: Line chart x-axis use values in stead of labels

What the OP is asking for is an XY chart. This is the type to show projects ranked according to investment return (ROI). PowerApps has some nice simple charting features that you can do quite a bit with, however XY charts are not one of them.
Verified answer

v-xida-msft on 29 Jul 2020 at 08:22:37

Like (0)

Report

Re: Line chart x-axis use values in stead of labels

Hi @HansHeintz ,

Do you want to plot different horizontal distance of the points against the difference in dates in your Line Chart control?

If you want to plot different horizontal distance of the points against the difference in dates in your Line Chart control, I afraid that there is no way to achieve your needs in PowerApps currently.

Just as you thought, the horizontal distance of the points of the 'Line Chart' control would be divided into equal distance against the records amount in your collection. Currently, there is no way to customize the horizontal distance of the points of the 'Line Chart' control based on the difference in dates.

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:
https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

As an alternative solution, I think Power BI report could achieve your needs. On your side, you could consider store your animal weight records in a Excel file, and then you could add your Excel file data as dataset into your Power BI desktop. The Excel dataset added into your Power BI may look like this:

Then you could plot a Line Chart based on the above inserted dataset in your BI report:

After that, you could consider pin above BI report to existing dashboard or new dashboard as a Tile. Then you could use the "Power BI Tile" control in your PowerApps canvas app to display the above Line Chart visual:

More details about displaying Power BI Tile in PowerApps canvas app, please check the following video resource:

https://www.youtube.com/watch?v=CWmU3gJ9tRY

https://www.youtube.com/watch?v=H9yYzPg0LwM

Please try above alternative solution, hope it could help solve your problem.

Regards,
eka24 20,921 on 29 Jul 2020 at 07:53:53

Like (0)

Report

Re: Line chart x-axis use values in stead of labels

Try watching this video from Shane Young
https://youtu.be/b8iz1ar1I4E?t=3

if you still have issues, show a sample of your table
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.