Forum Discussion

RoelVB's avatar
RoelVB
Icon for Helper I rankHelper I
5 years ago

column chart showing different result than area chart

Hi,   I have this report that doesn't make any sense to me. My results in a stacked column chart are different that in a stacked line chart: Note that the green area is missing in the column...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi RoelVB ,

 

When I open the sample report you provided, this information is visually prompted, which will result in incomplete visual display.

 

Unfortunately, there is no better way than to pre filter useless data in clientid field.

 

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

RoelVB's avatar
RoelVB
Icon for Helper I rankHelper I
5 years ago

Thank you for checking my sample.

 

That's strange. I don't get this warning, but this still raises some new questions:

  1. Why the difference between using the client's ID vs Name as value? There are the same amount of names as IDs
  2. Why the difference between de column chart and area chart?
  3. I don't have anything to "pre filter", we need all data

Maybe it's just me, but this makes Power BI hugely unreliable.

The person who found this issue also didn't get a warning about "too many values" and uses this report to manage his department.