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

Unfortunately no valuable input as yet. Did some more playing around and have simplified my dataset even more to see how this affects the output. See attached image. Really do not understand where this is coming from. The graph is going bonkers. Do you guys think i should raise this as support issue with MS?