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

      • 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