1 of 1 people found this helpful
Pie charts are particulary awful.
Two things for your issue.
The parameter technique uses conteiners to alternate views. It means that you won't use floating objects and will need to hide titles.
The worst part: Pie charts doesn't contract with null filters.
Solution: Build a calculation setting your dimension according parameter selection and use one sheet only. If you use different measures do the same for them.
If [Select a Sheet] = 'Category' then [Category] else [Market] END
If [Select a Sheet] = 'Category' then [Sales] else [Discount] END
Creating new calculated field and using only one sheet helps, thank you!
Hello Yin Yu Lam,
Can you please share me workbook that you have tried. Im in the same situation and tried as Vasconcelos mentioned.
Unfortunately I couldn't resolve that issue.
it will be helpful if you can suggest me.
Please see attached for the updated workbook - refer to the "Dynamic" sheet. It's been a while but I'm hoping this would still answer your question. Basically I create a calculated field named [Dynamic field] to dynamically change the variable that is used to determine the pie chart's sizes and colors based on the "Select a Sheet" parameter selection, instead of creating 2 individual pie charts that stacked on top of each other.
If you still need 2 individual pie charts, I have also found this trick to be helpful to hide the reserved white space when the pie chart shouldn't show - creating a dummy variable and add it to the column shelf for both pie charts, and do not show Header (right click, uncheck "Show Header"). I have also included this dummy variable in the "Category" and "Market2" worksheets in this attached workbook. I found this solution some time ago from Tableau community (if I recall correctly), but can't seem to find the original post now.
Hope this helps!
piecharts_switchview.twbx 8.1 MB