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.

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

AnalyticPulse 
The data for each tenant is hosted in each tenanted database - Thus, there is no reason to add dynamic RLS in this case. 
We are not displaying the KPIs in a tabular format. These would have to be cards.