Hi there,
I have a pie chart which is displayed in %. In order to get the pie charts to display % i created calculated fields on my existing measures to show the value/total * 100.
In some cases, these calculated fields show 0% - please see screenshot attached. How do I go about setting a rule not to display the mark label when a measure has 0%?
Thank you!
Nadia
Hi Nadia,
You are right: Now Name means different things depending on what data source you use.
The solution for this is to use a PARAMETER.
You have to create a parameter (in the attached example I called it "Current Name" and populate it from a field. This field will be the "Name" of any of your data sources.
Now modify the filters, select "Use All" in the "General" Tab, then in the "Condition" Tab you will have to select "Formula" and type in "[Name] = [Current Name]"
You do this for your filters (only twice if you have selected use filter in all worksheets using this data source).
Now you go to your dashboard and add the Parameter to the dashboard. Also, you delete other filters related to name.
Now when you select a name from the list (the parameter), everything coordinates.
Hope this is clear enough.
Yours,
Alfredo
