@I am trying to display something similar to Ken Flerlage's this post.
https://www.kenflerlage.com/2018/01/percentage-gauges-in-tableau.html
I am not using his method because I don't want to use the additional Excel file which is needed for his solution but concept is the same. I want to display Department's Revenue % to Total Revenue. And the catch is we are implementing row level security on Department field so when every Department Head will check the dashboard, he or she should see only their respective Department's Revenue % to Total.
Per this data, if Apparel Head checks the dashboard, he/she should view only 8% of the Pie chart filled up and rest should be White. Based on my current version, I am getting the value as 8% but my entire Pie chart is filled up with that color.
twbx is attached here.
Desktop version: 2019.2
null
When you apply row security, it actually filters out all the other data. Without the other data, there is no way to know what percentage each department accounts for. Within the data set Tableau has to work with, that department will be 100%. That being said, I think the only way to do this would be to calculate your percentage outside of Tableau, then use that static measure for the chart.
