Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

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

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.

wzuniga_1-1637693191262.png
wzuniga_2-1637693234815.png

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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 

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.