Forum Discussion

Mark1982's avatar
Mark1982
Icon for Helper I rankHelper I
6 years ago
Solved

Weird results in graph

Hi,   I've been building many Power BI dashboards and reports on vairous different data sources. This time i am experiencing an issue which has me baffled.   The scenario is simple. One SQL Table...
Need Help
  • Mark1982's avatar
    Mark1982
    6 years ago

    Right,

     

    My last reply has led me to dig deeper into the decimal spacing. Clearly i am facing an overflow issue within the graph output. When tranforming the amount field to fixed decimal resolves the issue. The SQL column amount is set to decimal 38,20 whilst Power BI decimal "number of significant digits is limited to 17 decimal digits". This clearly conflicts. I am stunned that this only seems to overflow on the graph. That has send me in the wrong direction.

     

    Seems like I just created a nice knowledge base topic for the community :).

Mark1982's avatar
Mark1982
Icon for Helper I rankHelper I
6 years ago

Right,

 

My last reply has led me to dig deeper into the decimal spacing. Clearly i am facing an overflow issue within the graph output. When tranforming the amount field to fixed decimal resolves the issue. The SQL column amount is set to decimal 38,20 whilst Power BI decimal "number of significant digits is limited to 17 decimal digits". This clearly conflicts. I am stunned that this only seems to overflow on the graph. That has send me in the wrong direction.

 

Seems like I just created a nice knowledge base topic for the community :).