How to create a line graph with multiple checkpoint status's

[dosania]

Hi,

I've wireframed a visual and would like to know if it's possible to make this in PowerBI.

For a Claim, I want how it was performing at various checkpoints during it's lifecycle (25%, 50%, 75%, 100%) for the reserve amount we placed on it, against the total.

I like the visual to show how much had been paid, and was oustanding based on the number of days on the Claim, which are the checkpoints above. Is it possible to do this using constant lines or error bars in the way I have shown below?

I can calculate how much has been at the various check-points on the lifecycle of the claim.

Any help or alternative suggestions would be much appreciated.

Thanks

[Anonymous · Accepted solution]

Hi @dosania ,
Based on your description, your y-axis seems to be the date, so the constant line for comparison by value should be standardized on the y-axis. Then you can use the Analyze pane in Power BI Desktop to create the y-axis constant line.
Click on the visualization and select the analysis pane. You can also rename it

You can create the values you want here or use measure to get the data dynamically.

Show the name of the line

Final output

Use the Analytics pane in Power BI Desktop - Power BI | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[pbiuseruk]

Hi,

I'm not sure if you can use a constant line to do this as they're generally straight horizontally and they have no movement in the y plane. I'd suggest maybe make a small table and just 4 or 5 values in there like this:
0%, 0
25%, 5,
50%, 10,
75%, 15,
100%, 20

This is just an example but then you'd link the percentage column to the percentage column in your actual dataset. Then you can use an average line on this second column and that would give you a straight line that goes up (you can change the values and increments as needed).

Without actually seeing the dataset, this is what I'd recommend.