Forum Discussion
Rdarshana
1 year agoHelper II
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...
AnalyticPulse
1 year agoSolution Sage
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
1 year agoHelper II
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.