Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi,
I am creating a role to blank out a certain field in my Power BI Report to a bunch of users and I am unable to do that for multiple fields. How do you create a role that blanks out multiple fields?
Hi @nasheno ,
We can filter out multi fields by || when we create roles in power bi desktop.
[Category] = "A" || [Category] = "B"
Thanks for your reply. In your table below, if I want to exclude only certain columns for example sales, how do I do that?
| User | Count |
|---|---|
| 17 | |
| 11 | |
| 11 | |
| 8 | |
| 7 |
| User | Count |
|---|---|
| 39 | |
| 36 | |
| 35 | |
| 34 | |
| 20 |