Conditional Formatting for Clustered Column Chart Based Off Current User Viewing the Report

[samjcarroll]

I am trying to figure out a way to create a clustered column chart with conditional formatting. The data compares a few metrics across several users of the report. I want the current user's columns to be saturated colors and the other user's data to be desaturated and lightened. See the below example from Excel.

Anyone know of a way to accomplish this in Power BI so that it is dynamic based on which user is viewing the report?

[Anonymous · Accepted solution]

Hi @samjcarroll ,

Regarding your question, you can achieve your goal by using the 'USERPRINCIPALNAME()' function in conjunction with conditional formatting.First ensure that the data stores the email address used by the user to log in to Power BI Service.

Use the following DAX expression to create a measure(1 for opaque, 0.3 for 30% transparent)

Measure = 
VAR _a = USERPRINCIPALNAME()
VAR _b = SELECTEDVALUE('Table'[Email])
RETURN IF( _b = _a,"rgba(0,0,200,1)","rgba(0,0,200,0.3)")

Setting the Conditional Format

If you have multiple columns on the x-axis, setting the conditional format is not supported and it is recommended that you use a matrix.

Final output in service