How to CALCULATE line based on Axis(Date) on Line and stacked column chart in Power BI

[snuppie]

After struggling builded this visual for a week, I've finished making columns on the visuals.

Then I got the new issue and doesn't know how to get through it.

The thing I want to make it is the line that also display on the same visual as the columns with depending on DATE (appear as AXIS)

However I have no idea how to make the DAX correctly or which one is the answer for this issue.

I also post the visual as below,

[v-yulgu-msft]

Hi @snuppie,

If you want to show the total value for each year-month on Line and Stacked column chart, you just need such a similar measure, add it to "line" section.

LineValue=SUM(TableName[QTY])

For more advice, please provide sample data and show us desired result.

Regards,

Yuliana Gu

[snuppie]

@Anonymous as your advide, I already made new measures of LINE CHART (Budget line)

( Same DAX as Column value).

Now it shows correct value as I want to display that align with Asix, even though in the line values component by different values.

So I got the new issue now XD, the dot don't connect together to be the line as I want to.

Is it possible to connect all the dot in differrent measure (value)?

Picture as below;

[Anonymous]

Can you check if the stroke width is 2 in format shapes?

[snuppie]

After struggling builded this visual for a week. I have just finished the columns that I want to display them on the visual.

Then I got the new issue and doesn't know how to solve it...

The thing that I want to make it is the line that show its value depends on Date that display on the visual.

Question is how can I calculate it? and what DAX gonna be my answer for this issue?

I have a picture as below to show you,

[Anonymous]

The problem is:

Your budget totals are not getting filtered by the date. If you observe closely, the budget shows same total for all the years/months.

Reason:

Filters are not working correctly.

Solution:

Date field should be on the one side of the table relationship and budget measure/calculated column should be in the many side of the table relationship.

Alternate Solution:
Rework on how you are calculating the budget measure. You can show the dax here. Also show the relationship view of the tables.