Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
If we are selling a certain product, we may be unable to offer another product/service line. I would like to format fields in a matrix based on text in other fields; please see the image below. This was built using a product column and a client column, the X represents products the clients have purchased. I want the product fields that we cannot offer to be grey. Is it possible to recreate this in PBI?
Thank you
Hi @djoellet ,
Based on the information provided, your conditional formatting measure would go something like this:
conditional formatting =
VAR __PROD =
SELECTEDVALUE ( data[product] )
VAR __PROD_A =
CALCULATE ( [my measure], data[product] = "A" )
VAR __PROD_B =
CALCULATE ( [my measure], data[product] = "B" )
VAR __PROD_C =
CALCULATE ( [my measure], data[product] = "C" )
RETURN
IF (
(
NOT ( ISBLANK ( __PROD_A ) )
&& __PROD IN { "B", "D" }
)
|| (
NOT ( ISBLANK ( __PROD_B ) )
&& __PROD = "D"
)
|| (
NOT ( ISBLANK ( __PROD_C ) )
&& __PROD IN { "D", "E" }
),
"gray"
)
Replace [my measure] witht the actual measure you use for X and gray with another color or hexadecimal code. Gray's hex is #808080 but it may vary depending on the hue you want.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
74 | |
71 | |
39 | |
27 | |
27 |
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |