Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Formula To Retrieve Data from Last Year Month In Same Column

Hi    I currently have a clustered column chart as follows.                  - The measure used has data dating back to 2016.  - The green bar is Last year figure ie July 2017 August ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Yuliana 

 

The options i have are as below

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Please make sure the [date] field added to visual is formatted as date, rather than date hierarchy. Please check the difference from below screenshots.

             

    

 

Best regards,

Yuliana Gu