This visual cannot be displayed. The data in this graph contains infinite values HELP

[Syndicate_Admin]

Hello good day!
I have the following problem for the visualization of a graph that contains the following construction based on measures (they are specified in the attached image), the problem is that the graph throws me the following message "This visual object cannot be displayed. The data of this graph contain infinite values" and as you can see in the table on the side (conversion of the graph to table) it is clear that the measurement is throwing the value at infinity which I do not know how to correct.

[v-chenwuz-msft]

Hi @Syndicate_Admin ,

Please change the Durofel Comparativa to the following expression to check if the "Ranco" has match rows in the table in the switch funtion.

Durofel Comparativa = 
SWITCH(
SELECTEDVALUE('Comparativa'[Comparativa]),
"Ranco",1,
"Región",[Durofel por Grupo],
"Productor",[Durofel por Ranco])
)

If the result of Ranco is 1 then the problem is the measure [Durofel por Packing Nuevo].

If no 1, the preblem is "Ranco" ,maybe the string with some blank space in the end.

Please share the pbix remove or replace the sensitive data and i will hele you.

Best Regards

Community Support Team _ chenwu zhu

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

[amitchandak]

@Syndicate_Admin , You are using selectedvalue in the first formula, Check if something is selected or not. If not select one value in the slicer or add a default value to selectedvalue