Forum Discussion
Power Bi Table Auto Scroll Effect
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.
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.
I get stuck in a circular dependancy error
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.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.