Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

single date picker in powerbi

hi   i need to select single date in my report so that business have  greater interaction with the date visual . I know that single date  picker will be vailable in list or dropdown but i dont need...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

jsh121988  : is there any similar visual which you could aware of  for single date picker . Thanks for reply

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous ,

May be your could have a try with before or after slicer in Power BI.

 

 

Best  Regards,

Cherry

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-piga-msft  before or after is not for one date right?. in your below screenshot it takes the range of data from 1/1/2019 to 3/6/2019 . But i need in the same calendar visual which gives the data for 3/6/2019 . I want the user to have claendar visual not the drop down or list format .

    • jsh121988's avatar
      jsh121988
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      Before or After can work, but you need to create explicit measures that use the LASTDATE() or FIRSTDATE() as a filter, depending on before or after repectively. My only conern is that it may confuse users, and it can possibly give you more overhead if you need to create a measure for everything (even though I intentionally create measures for everything).

      MyMeasure = 
CALCULATE(
    SUM(Table1[Col1]),
    LASTDATE(Table1[Date])
) 
      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        jsh121988  : yes this creates uncessary confusion .