line chart to display comparison of sales of two months based on days

[dsmitha]

Hi,

I have a line  chart in my dashboard which displays  date wise sales based on months selected from slicer.  Now my boss wants multiple months to be selected via slicer  and accordingly  sales for the date should be displayed   i.e. if we select from slicer "August" and "September" then the  chart should display sales of August and September against respective dates  

screenshot displaying date wise sales for September month, how can we include August also in the same chart

kindly advise

regards,

dsmitha

[parry2k]

@dsmitha Are you using calendar table in your model? 

[dsmitha]

hi parry2k,

am using a data table

regards,

dsmitha

[rsbin · Accepted solution]

@dsmitha ,

I'm hoping you are using a Date Table connected to your SIM table.

If so, drag DayNumber into your x-axis, and drag Month into your Legend.

The Line Chart should then show a separate line for each Month selected in your slicer.

If you are not using a separate Date Table, then simply create calculated columns for Day and Month off your Created_Date.

Regards,

[dsmitha]

hi rsbin,

Thank you very much for your  express  solution, it worked fine.  I even changed the visual to clustered column chart .  

thanks again

regards,

dsmitha

[rsbin]

@dsmitha ,

Glad it worked out for you!