Combo Chart - Line & Column to show This vs Last Week Sales (Mon to Sun)

[mbagwan]

Hi, I need some help in creating a combo chart to show Weekdays on X axis Mon to Sun (I already have Dim_Date) and This week Sales in column and last week sales in a Line chart.
For an example, for this week (column) should only show data till today (Wednesday) and line should show all the data from previous week starting from Mon to Sun.

[barritown · Accepted solution]

Hi, 

I'd solve your problem with the help of these two measures:

ThisWeekValue = IF ( MAX ( DIM_DATE[Date] ) <= TODAY(), MAX ( [Sales] ), BLANK() )

PreviousWeekValue = CALCULATE ( MAX ( [Sales] ), FILTER ( ALL ( DIM_DATE ), DIM_DATE[Date] = MAX ( DIM_DATE[Date] ) - 7 ) )

You may want to check the PBIX file here - https://www.dropbox.com/s/6hhwa92xmlpqq49/pbi-combo-imp.pbix?dl=0