Forum Discussion
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
- parry2k
Super User
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
- amitchandak
isblank(table[field]) can be used to check. What did you want to do?
- amitchandak
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
