Forum Discussion

ginalu's avatar
ginalu
Helper I
2 years ago
Solved

Same Chart, Different Counts

Why do the values presented in the same chart differ when placed on different sheets? The filters, XY axis, and values are exactly the same on both sides.   The only difference is the chart r...
Need Help
  • TheoC's avatar
    TheoC
    2 years ago

    Hi ginalu 

     

    There are a few things to check just to please check:

     

    • Click on View tab and click on Selection. This will bring up a pane on the right-side of the screen.  Review it to ensure there are no hidden objects or elements that might be creating the discrepancy. 
    • Once you complete the above, click on Sync Slicers.  Similar to the above, it will bring up another pane on the right-side of the screen. Ensure that there are no slicers from other pages that are influencing the visual outputs.

     

    Once you've done the above, I recommend creating a new page and recreating it from scratch.  Do not use any Page or Visual level filters.  ONLY USE SLICERS to recreate the filters you want to see on the visual.  This will ensure you are able to error-check the process properly.

     

    Please let me know how it goes.

     

    Theo 🙂

     

     

TheoC's avatar
TheoC
Community Champion
2 years ago

Hi ginalu 

 

It could be that you have Distinct Count and standard Count selected on the visual, itself.   

 

If you click on the little down arrow, you will find that Power BI allows you to choose from two options: Distinct (Count) or standard Count.  Distinct (Count) is when a string or value appears more than once but is only counted once. For example, if a data population was made up of A, A, A, B, B, you will have a Distinct (Count) of 2.   This is different to the standard Count of 5 (given there are five actual values).

 

 

Hope this makes sense and is of some benefit. 🙂

 

Thanks heaps,

Theo