Forum Discussion

Narasimha's avatar
Narasimha
Helper I
9 years ago

Last 4 weeks data

Hi team..i want to display last 4 weeks data in column chart. At any point it is showing 4 weeks data. Could you please help me with step by step process.
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi alanhodgson

 

Your soloution matches my requirment, but it is not working for me. I have created caluculated coloumnas like you said

 

Last Day of Week2 = 'Datekey'[Date]+MOD(8-WEEKDAY('Datekey'[Date],1),7)

alanhodgson's avatar
alanhodgson
Solution Supplier
9 years ago

Hey Anonymous,

 

Make sure you are putting the Date field that you use for the calculated column into the "Axis" part of the visual.

 

Other than that, it looks correct to me. I was also able to recreate the same column again and it worked fine.

 

Hope this helps,

 

Alan