Forum Discussion

ICW1972's avatar
ICW1972
Regular Visitor
2 years ago

Inaccurate Measures Shown in Visualization

I have a Power BI model that uses an area chart, but the problem shows up with line charts as well.

 

I have queried my data using Dax Studio and a CALCULATE function; the function returns the sum of requests for a given day.  The value from this query is then checked against data in an external system that is the source of my Power BI model.  Using KQL, the query returns the same exact value for any given day in the month of September.

 

Examples here are for 14th - 15th where the total 8,841 for a given value in APIKey.

 

Log Analytics

 

The chart in Power BI gives me a much lower value; oddly however, the line charts map the dip in the second image.  It's like it is only using a fraction of the total (hundreds for a day instead of thousands).

 

I extracted the Dax Query used by the visualization and see the same filters being applied.  I copied my model and deleted every single report except one and removed every filter except the APIKey and still get the same result.

 

So the Power BI model has the exact figures according to Dax Studio as what Azure has; but Power BI only shows a fraction of the daily sum.

 

I'm using a grid on another report in the same Power BI file and it shows totals that match as well (same date slicer).  It's like anything involving lines, areas, etc. the X-axis "loses" data, but keeps the same outline so far as shape is concerned.

 

Same correct 8,841 value shows up on the grid for right date.

 

 

 

 

1 Reply