Forum Discussion

iioannou's avatar
iioannou
Helper I
8 years ago
Solved

Single Date Selection

Dear Power BI,     Can you please let me know if there is option - slicer for single date selection ? We need this because we will be building reports such as Daily, MTD, YTD and we wish the user ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI iioannou,

     

     

    For your requirement, you need to create new calendar which not related to current table to ignore filter effect.(create relationship to new table also not allowed)

     

    Then use new table as source of slicer, then write a measure to get selected value.

     

    After these steps, you can use above measure as filter parameter with your calculation formulas.

     

    Regards,

    XIaoxin Sheng