Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Power Bi Table Auto Scroll Effect

Hello! I have a Power Bi dashboard that I want to display in a warehouse to show performance of workers. I followed this helpful video (https://www.youtube.com/watch?v=xhCqCkf0gMQ) that gave me the e...
workspaces
  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    Hi Anonymous 

    The circular dependency error is likely caused because the [Performance Measure] referenced within the RANKX function relies on the same table or measure context that is being ranked. This is a common issue, particularly when the ranking is performed in the same visual as the performance measure calculation, creating a recursive dependency.

     

    Index =

    RANKX(

       ALLSELECTED('Labor_data'[Associate Num]),

       CALCULATE(MAX('Labor_data'[On Standard % (No Zeros)])),

       ,

       ASC,

       DENSE

    )

    If you continue to experience this issue, please share the .pbix file or a sample version of it. This will allow us to review the data model and measure dependencies in detail, so we can easily identify the root cause and provide better support.


    Regards,
    Karpurapu D,
    Microsoft Fabric Community Support Team.

v-karpurapud's avatar
v-karpurapud
Community Support
1 year ago

Hi Anonymous 

Thank you for reaching out to the Microsoft Fabric Community Forum.
 

To create an auto-scrolling dashboard in Power BI, you can use the RANKX function together with ALLSELECTED. This ensures that ranking only considers data points visible with current filters, like date slicers, and excludes historical data you don't want included. This method helps support the scrolling effect for your dashboard.

You can use the following DAX measure:
 

Index =

RANKX(

   ALLSELECTED('Labor_data'),

   [Performance Measure],

   ,

   ASC,

   DENSE

)

Be sure to replace [Performance Measure] with the metric you want to use for ranking, such as MAX('Labor_data'[On Standard % (No Zeros)]).

Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    I get stuck in a circular dependancy error

     

    • v-karpurapud's avatar
      v-karpurapud
      Community Support
      1 year ago

      Hi Anonymous 

      The circular dependency error is likely caused because the [Performance Measure] referenced within the RANKX function relies on the same table or measure context that is being ranked. This is a common issue, particularly when the ranking is performed in the same visual as the performance measure calculation, creating a recursive dependency.

       

      Index =

      RANKX(

         ALLSELECTED('Labor_data'[Associate Num]),

         CALCULATE(MAX('Labor_data'[On Standard % (No Zeros)])),

         ,

         ASC,

         DENSE

      )

      If you continue to experience this issue, please share the .pbix file or a sample version of it. This will allow us to review the data model and measure dependencies in detail, so we can easily identify the root cause and provide better support.


      Regards,
      Karpurapu D,
      Microsoft Fabric Community Support Team.

      • v-karpurapud's avatar
        v-karpurapud
        Community Support
        1 year ago

        Hi Anonymous 

        I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

        Thank You.