Forum Discussion
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 range of the country filter. The first sheet filters this visual effect, while the second sheet filters this page. However, for this bar chart, both sheets have the same filter criteria, but the daily register numbers are different. Additionally, the first sheet only has the value for Taiwan in the country filter. I'm not sure where the problem lies.
The first sheet:
the second sheet:
- Why do the values differ when duplicating the same data card on the same page? The filters, XY axis, and values are exactly the same on both sides.
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 🙂
4 Replies
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
Hi TheoC ,
Thank you for your reply. I have reconfirmed that standard count is used in all calculations. Attached are two sheets with detailed settings.
The only difference is the chart range of the country filter. The first sheet filters this visual effect, while the second sheet filters this page. However, for this bar chart, both sheets have the same filter criteria, but the daily register numbers are different. Additionally, the first sheet only has the value for Taiwan in the country filter. I'm not sure where the problem lies.
The first sheet:
the second sheet:
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 🙂
