The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am trying to set a rule on a measure if the value is greater than 100% to turn the background color to green.
It its a legitimate number going greater than 100% but I am getting an Logic error.
Can this be fixed /any workaround. Kindly suggest.
Solved! Go to Solution.
Don't use 'Percent' in the drop down, use > 1 'Number' and < 1000 'Number'
The Percent option does not have anything to do with acual percentage values. It looks the the percentag of the total dataset that falls into the range.
Don't use 'Percent' in the drop down, use > 1 'Number' and < 1000 'Number'
The Percent option does not have anything to do with acual percentage values. It looks the the percentag of the total dataset that falls into the range.