cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
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):

navafolk_0-1593417215594.png

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Helper III
Helper III

Re: Chart to show/dispaly infinity

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

Highlighted
Community Support
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)

Ratio.JPG

Best Regards

Rena

Highlighted
Helper III
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
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:

filer not blank.JPG

Best Regards

Rena

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

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

Upcoming Events

Experience what’s next for Power BI

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

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors