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
RoelVB's avatar
RoelVB
Icon for Helper I rankHelper I
5 years ago

I did a lot of testing. And it gets crazier.

 

Here I use the ClientId as legend (this is NOT the related table, it's the ID inside the Projects table):

 

Here I use an anonymized client name, and everything is fine:

 

And with the actual client names:

I checked for double clientnames, but there are none.

 

Here's an anonymized PBIX: https://we.tl/t-8zS8CTHq8G

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.