Line and Clustered Column, Line is summing for each cluster.

[wonka1234]

Hi,

I have a chart like the following , which looks like its aggregating the number for both stacks. 

For example - June 2025 should show 6 for light blue and 15 for dark blue (overdue formula) . Not 21 total.

X Axis = Date 

Column Y Axis = Count of Records

Line y Axis = Overdue (measure i created)
Legend = the 2 different business lines.

Is there a way I can do this?  Or is there a better way to visualize this?

Thanks.

[v-saisrao-msft]

Hi @wonka1234,

We haven’t heard back from you in a while. If your issue has been resolved, Mark the relevant response as the solution to help fellow community members.
If you still need support, let us know if you still need assistance.

Thank you.

[v-saisrao-msft]

Hi @wonka1234,

checking in to see if your issue has been resolved. If the response provided was helpful, kindly mark the helpful reply as solution so that others with the same issue can benefit.
let us know if you still need assistance.

Thank you.

[v-saisrao-msft]

Hi @wonka1234,

I hope you had a chance to review the solution shared earlier. If it addressed your question, Consider accepting the helpful reply as solution it helps others find answers more quickly.
If you're still facing the issue, feel free to reply, and we’ll be happy to assist further.

Thaank You.

[v-saisrao-msft · Accepted solution]

Hi @wonka1234,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Using the sample data, I have recreated the scenario. Please find the screenshot and PBIX file below for your reference.

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

Thank you.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[amitchandak]

@wonka1234 , You can use a marker on the line and make the line width =0, then it will show only the Marker. 
You can also consider label customization to show additional values in the above label only 

https://youtu.be/krmhv9CAKDw