I like to show the contribution of selected dimensions graphically (treemap, pie charts or simple stacked bar charts) within the same view. The issue I have now is that each time I filter down, the 'total' measure will be lost as only the filtered data is collected. In simple terms, I want to keep the total 100% constant, while overlaying the 'selection' on top to show the share on one graphic. Is this possible?
Appreciate any assistance.
The filter will take the data/dimension out of the view entirely, even when you want the total. However, this can be done by creating a calculated field and/or parameters. If you're able to post a packaged workbook (twbx file), I'll be able to help you further.