Forum Discussion

PremK's avatar
PremK
Icon for Resolver I rankResolver I
1 year ago
Solved

Page Level Security with Calculation Groups || Need Assistance

In my report i used Field Parameters to create a Matrics Table, but im facing Sorting issues. PBI is not remembering the sorting order i applied when i change the filed parameter value. so to overcom...
  • Akash_Varuna's avatar
    1 year ago

    Hi PremK  It might be because calculation groups interfere with the Pages column used for conditional navigation, as they override field references. So, for this, you can modify the UserPages table to include a unique PageID and use it exclusively for navigation logic. Ensure USERPRINCIPALNAME() filters the table based on the user's email, and keep calculation groups independent of the slicer and button setup. Use PageID for navigation while displaying PageName in the slicer to maintain dynamic functionality.