Need Help in Comparing data on line chart using set of slicers

[dipanshu_mittal]

Hi All,

I need help in creating a power BI desktop report for comparing data on a line chart based on the selection of year & month (can select multi year(s) & month(s) ) from the slicer and there are a few more slicers (can multi-select the values).

Data is represented on line chart visualization.

Problem Statement: When I am selecting multiple years or months data is summed up in a chart. Need to visualize the comparison between the year or month if multi-selected.

Thanks in advance

[amitchandak]

@dipanshu_mittal , when you select multiple values, what do you plan to compare with

if you want to compare with last year, you can have a measure like

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))