Forum Discussion

v-alipat's avatar
v-alipat
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Power BI Report Server January 2023 has been Released!

  We are pleased to announce the January 2023 update for Power BI Report Server. The release can be found on the Microsoft Download Center.    The changelog has been updated with the following ...
PBIRS
Releases
Report Server
RayLei's avatar
RayLei
Icon for Advocate I rankAdvocate I
3 years ago

Hi Bobi, How do you set the default value for the date slicer when SSAS Multidimensional with live connection is used? How do you fulfill a date visual like below when SSAS Multidimensional used?

 

Best regards,

Ray

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi RayLei,
 I do set the standard value under Role-->Dimension-->Attribut with the following value:
head(StrToSet('[your-time-dimension].[your-time-attribute].&['+Format(Now(),'yyyy-MM-ddT00:00:00')+']')).item(0)

BR Bobi

  • RayLei's avatar
    RayLei
    Icon for Advocate I rankAdvocate I
    3 years ago

    Hi Bobi,

    Kindly thank you for your prompt reply. If set the default value through role permission, user could not choose other date any more, right?

     

    I fullfill dynamic default date throught concept of DateID, 0 always represents today, -1 represents yesterday, 1 represents tomorrow, 2 represents the day after tomorrow, and so forth. In dimension design, using DateID as value column, and use actual date (yyyy-MM-dd) as name column.

     

    Power BI uses dimension value as internal value, thus the defualt date could automatically changes when actual date changing.

     

    Just for your reference.

     

    BR Ray

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi RayLei ,

      on the January 2022 version is possible to select another date over the date slicer i.e. the default value filters the data initally once the report is opened and loads it for the current date ( today) and then the user can select another period. Here is a screenshot from my report:

      I'm pretty sure it was possible on the june 2022 version, too. I cannot verify it right now. Definately it is not working on January 2023 version, since the dates are greyed out

      BR Bobi

      • v-alipat's avatar
        v-alipat
        Icon for Microsoft Employee rankMicrosoft Employee
        3 years ago

        Hi Bobi, 

         

        Thank you for reporting the issue, I'll forward it to the appropriate team and let you know when we find out the reason or any workaround. 

         

        Thanks,

        Alexandra