Forum Discussion
pettytester
1 year agoRegular Visitor
Can I omit certain Automatic Totals in a chart?
Hi guys, I have a Power BI chart that has labor funds, labor balance, labor expended, and a % of funds spent with automatic totals created by the chart. Everything looks great except the % total is showing as 800% (so obviosuly just summing up the columns).
I like this total row for the chart, but that value is misleading for that column. Can I omit it somehow? Turn that cell off?
Thanks!
1 Reply
- lbendlinSuper User
Use ISINSCOPE and/or HASONEVALUE to decide for each hierarchy level if and how to show the totals.