Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have Free PBI Desktop v2.100.1182 (64 bit free version Dec 2021) on Windows 10.
I have a measure called "Pct of Est Cost" which calculates a percent in a matrix. I want to make a conditional formatted background color but I get an error. PBI shows me a red "i" in a red circle. The error is "Please check the logic of this rule." I don't really see a problem. Here's my rule.
"Pct of Est Cost" is a measure:
The matrix also looks wrong as a value of 39% came out with a yellowish background. But I do not want all values to have a background color, some I want to have a background color of white. That's why I put in a minimum number of 200, then 2000. In both cases I have a Pct Of Est Cost had a value of 39% and a yellow background. I'd like values less than 200% to have a background color of white.
Solved! Go to Solution.
@croberts21 , I think it should be number, not percent. (percent is for distribution here)
if your column has been marked as percent column, then 200% will be 2 not 200
@croberts21 , I think it should be number, not percent. (percent is for distribution here)
if your column has been marked as percent column, then 200% will be 2 not 200
Thank you. Your hint helped me fix this, and I tweaked some numbers in the conditional formatting gradient.