Forum Discussion
DAX Percentage Range
Yes, there's a difference between the actual underlying numerical value and the way it's displayed (Format).
It sounds like you need to round the value to the nearest 0.0001 before displaying it in the chart.
here's the ROUND function, and an example of what the measure or new column should look like. All you need to do is put in the integer corresponding to how many digits after the decimal point you want to round, (sounds like 4 is the right number for you, 4 places after the decimal).
https://learn.microsoft.com/en-us/dax/round-function-dax
Statistical Attendance Presence Below Target % =
var attendance = ROUND('MIS: Attendance'[Statistical Attendance Presence %] , <put integer here>)
return
IF(attendance >= 0.90 && attendance <= 0.93, attendance, BLANK())
//Mediocre Power BI Advice, but it's free//
Solution SageYes, there's a difference between the actual underlying numerical value and the way it's displayed (Format).
It sounds like you need to round the value to the nearest 0.0001 before displaying it in the chart.
here's the ROUND function, and an example of what the measure or new column should look like. All you need to do is put in the integer corresponding to how many digits after the decimal point you want to round, (sounds like 4 is the right number for you, 4 places after the decimal).
https://learn.microsoft.com/en-us/dax/round-function-dax
Statistical Attendance Presence Below Target % =
var attendance = ROUND('MIS: Attendance'[Statistical Attendance Presence %] , <put integer here>)
return
IF(attendance >= 0.90 && attendance <= 0.93, attendance, BLANK())
//Mediocre Power BI Advice, but it's free//
I tried your solution this morning and it worked!!! I'm so grateful for your response. It was driving me mad and I couldn't see what I had done. A massive thank you once again.