Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
good morning, I need help in my power bi report to have a conditional formating that applies when two things happen. 1. If the Access right in dataverse shows as Organization which i have under a measure below
Access Level Text =
SWITCH(
'RolePrivileges'[privilegedepthmask],
8, "Organization",
4, "Parent: Child Business Units",
2, "Business Unit",
1, "User",
0, "None"
)
and
2. If the Role Privilege is contains any of the following in the description
Attachment
Note
Mail
I cannot use the ootb conditional formating so we will need to have the ability to use a measure to accomplish this.
Additionally, I would like a slice that would act like a toggle to turn off or on the conditional formatting measure in powerbi
I keep getting an "OLE DB or ODBC error" when I try to apply it.
Any help would be appreciated.
Solved! Go to Solution.
I would recommend doing this in Power Query. Create first a conditional column for your first case (Access Level Text). Then you can create a custom column to combine the logic with those results and Text.Contains (see documentation here). The outcome to place in each clause will depend on you, you can directly add a hex code to represent a color or you can even show characters (see how here ).
Regarding your second question, you can achieve it through bookmarks: create 2 visuals: one with the conditional formatting and one without it. Then show one visual and hide the other and save this state in a bookmark, then do viceversa to capture the other state.
Proud to be a Super User!
I would recommend doing this in Power Query. Create first a conditional column for your first case (Access Level Text). Then you can create a custom column to combine the logic with those results and Text.Contains (see documentation here). The outcome to place in each clause will depend on you, you can directly add a hex code to represent a color or you can even show characters (see how here ).
Regarding your second question, you can achieve it through bookmarks: create 2 visuals: one with the conditional formatting and one without it. Then show one visual and hide the other and save this state in a bookmark, then do viceversa to capture the other state.
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
87 | |
80 | |
69 | |
68 |
User | Count |
---|---|
227 | |
127 | |
118 | |
83 | |
78 |