Forum Discussion
Incorrect Counts in Power BI Chart with Custom Hierarchy
Hi varneet_hundal ,
If everything is coming from the same table you should get the correct results, check if you have any filter applied at report, page or visualization level.
To check if everything is fine I would start by adding my calculation without any hierarchy to my page and see if the value is correct, then start adding levels of the hierarchy starting at the highest level, that way you can filter out the information in the table view and check if the number match.
Super UserHi varneet_hundal ,
If everything is coming from the same table you should get the correct results, check if you have any filter applied at report, page or visualization level.
To check if everything is fine I would start by adding my calculation without any hierarchy to my page and see if the value is correct, then start adding levels of the hierarchy starting at the highest level, that way you can filter out the information in the table view and check if the number match.
Hi MFelix ,
Thank you so much for your help!
It turns out that one of the hierarchy levels had a filter applied, which caused the chart to display lower values than expected. Once I removed that filter, the numbers aligned correctly with the overall dataset.
Appreciate your guidance. It helped me troubleshoot and resolve the issue!
Best regards,
Varneet
