Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Default slicer value

Hi all,    I was wondering if anyone could help on this am I have a requirement to make power bi slicer defaults to the latest date the data load in my model. I have been able to create calculate...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi v-yadongf-msft  thanks . 
but my question was how do I make the current date default selection when it is published to power BI service . 

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi Anonymous ,

     

    Can you share with me some screenshots of your data after hiding sensitive information and tell me what's your expected output?

     

    Thanks for your efforts & time in advance.

     

    Best regards,

    Yadong Fang

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi above is my slicer where i use calculated column to grab Current_file 

      with  Max(Table[datecolumn])

      is there a way to show current_file the actual date let say 21 october instead 

      • v-yadongf-msft's avatar
        v-yadongf-msft
        Icon for Community Support rankCommunity Support
        3 years ago

        Hi Anonymous ,

         

        I'm confused about your calculation logic: 

        Latestdate= IF (file[date]=Max(filedate) 'Current-file', " " & file[date].

         

        Why did you use IF function instead of using Max(filedate) directly?

         

        Best regards,

        Yadong Fang