Infinity values handling in paginated report (Power BI power builder)

[Iuliia94]

Hello,

I'm new to Power BI power builder, and I'm trying to figure out how to handle infinity values in power builder (paginated report).

In power bi it's simple - iferror (A/X,0), however, in the paginated report same logic doesn't work on replacing infinity values with 0 or blanks, anyone has any insight on how to handle these values? 

[v-yanjiang-msft]

Hi @Iuliia94 ,

Please try to use the IIF function as below:

IIF(A/X = Infinity, 0, A/X)

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Iuliia94]

I've tried that one before and i get the following error: