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
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi v-alipat ,
it looks like there is an aissue with the date slicer when SSAS Multidimensional with live connection is used and a default value to the field over SSAS ( e.g. with head operation) is set. Then the calender is grayed out and nothing can be selected

Any ideas or workarounds ? 
On the June/Jan 2022 - Versions is working without any issues

Thanks!

Bobi

  • 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