Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Date Selection with Slicer

Hello,  I have a data set with date such as Jun 1 - Yesterday, I would like to have a slicer with two option, Yesterday / MTD.   How could I do that?   Thanks!
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Anonymous,

    Do you want to use a slicer to choose which measure(Yesterday or MTD) to display? If so, create a new table containing the measure name like below.


    Then create the following similar measures in your original table, please note that there is no relationship between the new table and your original table.

    salesMTD = TOTALMTD(SUM(Table6[Amount]),Table6[Date])
    salesYesterday = CALCULATE(SUM(Table6[Amount]),FILTER(Table6,Table6[Date]=TODAY()-1))
    selected measure1 = IF(HASONEVALUE(Table7[Measure]),SWITCH(FIRSTNONBLANK(Table7[Measure],Table7[Measure]),"Yesterday",[salesYesterday],"MTD",[salesMTD]),blank())

    Reference:

    http://breaking-bi.blogspot.sg/2016/06/power-bipowerpivot-using-slicers-to.html

    Regards,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Anonymous,

Do you want to use a slicer to choose which measure(Yesterday or MTD) to display? If so, create a new table containing the measure name like below.


Then create the following similar measures in your original table, please note that there is no relationship between the new table and your original table.

salesMTD = TOTALMTD(SUM(Table6[Amount]),Table6[Date])
salesYesterday = CALCULATE(SUM(Table6[Amount]),FILTER(Table6,Table6[Date]=TODAY()-1))
selected measure1 = IF(HASONEVALUE(Table7[Measure]),SWITCH(FIRSTNONBLANK(Table7[Measure],Table7[Measure]),"Yesterday",[salesYesterday],"MTD",[salesMTD]),blank())

Reference:

http://breaking-bi.blogspot.sg/2016/06/power-bipowerpivot-using-slicers-to.html

Regards,
Lydia Zhang