Forum Discussion
Conditional Formatting based on two conditions
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.
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.
1 Reply
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.