1E + 308

[Almantas32]

Hey guys, 

I I am trying to calculate the Rate of Leads Comming in and Out of the sales pipeline, but I have problems showing it in a chart. In the table the rate is shown correctlly, but in the chart it is all messed up and 1E + 308 giberish appears. What am I doing wrong?

Appreciate the help. 

[v-xicai]

Hi @Almantas32 ,

You may select on the [Rate Lead In/Out],  go to Column tools or Measure tools, se the data type as Decimal number, also set decimal places for it.

Best Regards,

Amy 

Community Support Team _ Amy

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

[Almantas32 · Accepted solution]

Thanks for the reply, turned out what I actualy wanted was to not show the infinity result, or show it as a such, Changing the formula from 

Rate Lead In/Out = [Count Leads In] / [Count Leads Out] to

Rate Lead In/Out = DIVIDE([Count Leads In], [Count Leads Out]), 

did the trick I think. At least for now. 

Thanks again.

[amitchandak]

@Almantas32 , check the data type a source. Correct it in power BI in edit transformation mode.