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 pros,
I have to draw a chart to show movement of a ratio and its threshold (Ratio is regulated to be above threshold)
Ratio=DIVIDE(numerator,denominator)
However, when denominator comes to zero, chart shows blank moves. like this (the period at the end of the chart):
Is there anyway to show a sign/comment/note... that this period has infinity ratios. Infinity ratio is super super over threshold rather than looking like under threshold/falling down like this?
Really appreciate this, thank you all.
@navafolk , you can create a measure that can be used as tooltip only display 0 when the denominator is 0. First, create that as bar do conditional formatting and convert the visual as line visual. It will show color dots.
Hi @navafolk ,
You can update the formula of your measure "Ratio" as below:
Ratio = DIVIDE('Divison'[Numerator]+0,'Divison'[Denominator]+0,0)
Best Regards
Rena
Thank you, @v-yiruan-msft,
I can understand your formula convert infinity ratio to 0 but Infinity ratio is super super over threshold. 0 ratio is like we breach something (0 is far below threshold requirement of 100%).
Hi @navafolk ,
Maybe we can apply a filter on measure "Ratio" as below to only display non-blank values:
Best Regards
Rena
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |