cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Handling infinite values in Power BI.

Hello everyone, 

I am working with the economic data of the all of the world countries. There are some indicators which have been expressed in the national currencies of these countries. In order to compare and visualize this data I just connected to the Currency API and created valueinUSD column which lets me to visualize the indicators. But when I connected to the Currency API, it did not provide me with exchange rates of 3 countries. In the ValueinUSD column these 3 countries' data is expressed with the infinite (∞) sign which creates me a lot of problems while visualizing the data. 
I would like to ask you how can I get rid of these 3 infinite values without changing Currency API.

 

Thanks in advance.

7 REPLIES 7
Super User IV
Super User IV

Re: Handling infinite values in Power BI.

@Anonymous when you are pulling the data, what do you see in power query? Do you see error? or null value? What does it shows there? If it is error you can replace error values with 0






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Super User IV
Super User IV

Re: Handling infinite values in Power BI.

Try to use IFERROR

 

Refer :https://community.powerbi.com/t5/Desktop/Handling-infinity-value/td-p/125435

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @

Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


Anonymous
Not applicable

Re: Handling infinite values in Power BI.

When I pull the exchange rates it shows blank ( not 0 or error).

Super User IV
Super User IV

Re: Handling infinite values in Power BI.

isblank(table[field]) can be used to check. What did you want to do?





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


Anonymous
Not applicable

Re: Handling infinite values in Power BI.

As I mentioned in the main question I have some data in National currencies and I wanted to express them in USD so I wrote a DAX  to create new column. But the API I have connected does not provide exchange rate for 3 countries out of 192. Because of the in the USD value column I am getting infinite value sign for these 3 countries' data. 
I hope I could explain myself.

Super User IV
Super User IV

Re: Handling infinite values in Power BI.

@Anonymous we can go back and forth all day long, you need to show sample data ,and if it is giving blank (not 0 or error), what is the business logic to handle when there is no value. You have to provide that information so that we can assist otherwise we don't know what your expectations are ? Hope this helps and read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Anonymous
Not applicable

Re: Handling infinite values in Power BI.

Problem is solved with IFERROR function. Thank you so much all.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors