Forum Discussion
Helper IPower BI Desktop Table Total not considering slicer
I have a Table in my report having orders in the rows and revenue in the column. Then I have a total in the buttom. This works fine, but I have a slicer with the fiscal year, and when I there choose for instance 2015 the orders in my table adjusts accordingly, but the Total remains the same, it doesn't consider only 2015. I would like that my total reflects the selection. How do I do that?
I am not seeing this behavior with a simple table and slicer. Are you on the August version of the Desktop? Can you post your data and maybe a couple screen shots?
2 Replies
- Greg_Deckler
Community Champion
I am not seeing this behavior with a simple table and slicer. Are you on the August version of the Desktop? Can you post your data and maybe a couple screen shots?
Morten_DKThanks for your reply. It helped me realize that there was something wrong in my datamodel. I found that one of my relationships was not working properly resulting in the total being fixed instead of considering my slicer.