Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
The data going to my tachometer is a division of two columns, and some of the values in the denominatior column are zero - which brings the start value of tachometer to infinity.
I do not want to change the data to a measure using IF or DIVIDE and place 0 or 1 as start value. So without doing any change in the data, can I change the widget to remove this infinity in start value?
TIA
Solved! Go to Solution.
Hi a_chhibber,
From your description, it seems you don't want to replace infinity with 0 (or 1), and modify the underlying data model, right?
When you do divide aggregation, you can replace 0 with other value which you want, eg 1:
Measure = Max([Column1])/IF(Max([Column1])=0,1,Max([Column1]))
Regards,
Jimmy Tao
Hi a_chhibber,
From your description, it seems you don't want to replace infinity with 0 (or 1), and modify the underlying data model, right?
When you do divide aggregation, you can replace 0 with other value which you want, eg 1:
Measure = Max([Column1])/IF(Max([Column1])=0,1,Max([Column1]))
Regards,
Jimmy Tao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |