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

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Based on my test using power bi desktop version : 2.78.5740.861 64-bit (February 2020). I cannot reproduce your issue here. Did you set any filter to your visual? Also you can share your sample data and excepted result to me by removing Confidential Information. Please upload your files to One Drive and share the link here.

 

Anonymous's avatar
Anonymous
Not applicable
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

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

    Thanks for sharing.