cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
a_chhibber Frequent Visitor
Frequent Visitor

tachometer - Removing Infinity

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: tachometer - Removing Infinity

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

1 REPLY 1
Community Support Team
Community Support Team

Re: tachometer - Removing Infinity

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

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 48 members 960 guests
Please welcome our newest community members: