Forum Discussion
Bar Chart - conditional formatting - diff colors based on upn
Hi pbidani - Create a new measure that outputs the user's club abbreviation as a label
Highlighted Club =
VAR _upn = USERPRINCIPALNAME()
VAR _UserClub = CALCULATE(
MAX('a-vw_sponsorship'[club_abbrev]),
'UserInfo'[user_email] = _upn
)
RETURN
IF(
MAX('a-vw_sponsorship'[club_abbrev]) = _UserClub,
MAX('a-vw_sponsorship'[club_abbrev]),
BLANK()
)
Currently, you can highlight the user's club visually in the bars themselves and add supporting elements (like tooltips, legends, or secondary visuals) for further differentiation. If the formatting of the axis labels themselves is critical, you may need to wait for future updates to Power BI or use a custom visual.
Hope it works, please check
- pbidani1 year agoFrequent Visitor
Thanks Rajendra.
I was trying to use the Format, X axis, Values, fx, and dax to make it work.
Thanks again!!