Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Chart showing incorrect value

I have two stacked column chart : chart one displays net sales sum by year (x axis) and other chart shows net sales by year (x axis) and product (legend). The first chart shows correct total net sale...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

    I resolved the issue myself. It was happening because the variable used in legend has 6k unique categories due to which the visual was not able to display each category value.

    Thanks

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yeah, but why it is showing all the values if I remove legend. Its just I am adding legend and values get reduced. Also, there are no additional filters applied.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

I tried on my system and it does not reduce the value(I taken at the item level to have quite a few values ). It could be because of some visual level filters. Or formula has some filter. Please share screenshot and formula

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
     

    As you can see left chart shows 1.2 M net sales whereas right chart shows some 15k net sales. Also the legend category - Master product formula is there in the image. There are no visual level filter or page level filter. I checked after exporting data from left chart that the total sum of net sales is 1.2 M which is not present in the chart.

     

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      6 years ago

      Can you share sample data or If possible please share a sample pbix file after removing sensitive information.Thanks.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Sorry, I am not allowed to transfer any data.