Forum Discussion

Rdarshana's avatar
Rdarshana
Icon for Helper II rankHelper II
1 year ago

Display KPIs per Products

Hello, I have a unique report development requirement that requires me to display KPI cards based on Products. For example, this is how the layout is: So, each block will contain metrics a...
Need Help
Show and Tell
AnalyticPulse's avatar
AnalyticPulse
Icon for Solution Sage rankSolution Sage
1 year ago

hi Rdarshana  one way to do this is to use the dynamic RLS, for this you have to create a new table for user id and the product access they have, then apply the dynamic RLS in powerbi desktop. if you use the bookmark method you have to create complicated logic in dashboard. i suggest you try dynamic rls.

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

 

Hi Rdarshana, if you want it dynamic based on the whoever is logged in then this is the approach. Injae has a tutorial on this on YouTube