cancel
Showing results for
Did you mean:
Highlighted
Helper III

## Chart to show/dispaly infinity

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.

5 REPLIES 5
Highlighted
Super User IX

## Re: Chart to show/dispaly infinity

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

Proud to be a Super User!

Highlighted
Helper III

## Re: Chart to show/dispaly infinity

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

Highlighted
Community Support

## Re: Chart to show/dispaly infinity

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

Highlighted
Helper III

## Re: Chart to show/dispaly infinity

Thank you, @yingyinr,

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

Highlighted
Community Support

## Re: Chart to show/dispaly infinity

Hi @navafolk ,

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

Best Regards

Rena

Announcements

#### Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

#### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021