Line and Stacked column chart not showing filtered line value

[bartvdg]

Line and Stacked column chart not showing filtered line value, the column values do change based on the slicer which is a date slicer.

example 1: slicer set to 2 months. line on chart showing totals for all months, not the months selected?

Should show orange line values , like table below, for months 2022-09 = 187.0 and 2022-10 = 178.5

I tried with summarization settings but doesn't help.

[bartvdg · Accepted solution]

I fixed it with below DAX:

Total Available Hours = CALCULATE(SUMX('dim - Input TimeSheetentry', 'dim - Input TimeSheetentry'[TAH per Month per Resource]), CROSSFILTER('fact - timesheetentry'[YYYY-MM endtime],'dim - Input TimeSheetentry'[YYYY-MM],Both))

[katika555]

@bartvdg  Please Share sumple data or file

[lbendlin]

You may need to use AVERAGE or MAX instead of SUM