Chart to show/dispaly infinity

[navafolk]

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.

[amitchandak]

@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.

[navafolk]

Thanks @amitchandak , could you be more specific? I do not really get it.

[v-yiruan-msft]

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

[navafolk]

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%).

[v-yiruan-msft]

Hi @navafolk ,

Maybe we can apply a filter on measure "Ratio" as below to only display non-blank values:

Best Regards

Rena