Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

change Date value in dashboard

Hello everyone
I want to display two dashboards one shows the sales of the selected year from slicer and the other show the sales (year-1)
I already did the mesures and everything is working fine but the date value in the dashbords is the same because i am using the same date table.
I want the date value of the dashbord in the bottom of the page to be 2021 not 2022

Thanks for your help

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , You need to use an independent date/year table in case you want to show trend of value other than the selected one 

     

     

    //Date1 is independent Date table, Date is joined with Table
    new measure =
    var _max = maxx(allselected(Date1),Date1[Date])
    return
    calculate( sum(Table[Value]), filter('Date', year('Date'[Date]) = year(_max) ))

     

     

    Last year =
    var _max = maxx(allselected(Date1),Date1[Date])
    return
    calculate( sum(Table[Value]), filter('Date', year('Date'[Date]) = year(_max)-1  ))

     

     

    Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    To the X-axis of the chart, you should drag Month only (from the Calendar Table).