Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi! Report users can see only data related to their own organization part (marketing sees marketing data, sales sees sales data etc) via row level security. How can I create dynamic title/texbox where this organization level/part is shown?
For example: user from sales-department opens report -> title/textbox shows "Sales department". User from marketing-department opens report ->title/textbox shows "Marketing department"
All organization data is in Dimension and row level security uses "organizationcode":
orgazationcode 100000 Sales
orgazationcode 200000 Marketing
orgazationcode 300000 IT
Solved! Go to Solution.
@tuulia , if organization and department are from different tables , we can use a measure from fact to make sure we use security , say measure is Fact measure
maxx(filter(values(department[name]),not(isblank([Fact measure]))), [name])
else
can share data model and RLS filters
@tuulia , Try a measure like and use that in tile or card visual
maxx(allselected(organization), [organizationcode])
concatenatex(allselected(organization), [organizationcode])
Thank you. I have allready tried allselected-functions but it returns all departments available in dimension. Users do not select anything from organizationslicer, row level security handles all filtering of data.
@tuulia , if organization and department are from different tables , we can use a measure from fact to make sure we use security , say measure is Fact measure
maxx(filter(values(department[name]),not(isblank([Fact measure]))), [name])
else
can share data model and RLS filters
This works, thank you very much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |