Forum Discussion

samjcarroll's avatar
samjcarroll
Regular Visitor
2 years ago
Solved

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

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 t...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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