Forum Discussion
Do not show a particular value when using Slicer
Hi All,
I have a cluster column chart that contains three values,
1. Planned Value
2. Earned Value
3. Actual Value
I'm using a slicer that contains various categories that are connected to Planned value and Earned value but not to Actual value.
So whenever, I'm clicking on any category in slicer then planned and earned value changes but not the actual value for the apparent reason (no relationship between the actual value and category table)
Is there any way that when I choose categories in the slicer, the Actual value does not display in the cluster column but only shows planned and earned value column?
Your help is appreciated.
Thanks and Regards,
Nilesh Jain
- You could update the Actual Value to use a measure:
Actual Value Measure = IF(ISFILTERED(Category), BLANK(), SUM(Actual Value))
Update accordingly for what Actual Value aggregation is using and add table names.
4 Replies
- Ashish_Mathur
Super User
Hi,
In the Table that the Actual value measure is based off of, create a Category column with no entries down that column.
Hi Ashish,
I tried that but the Actual values are still displayed becuase the category table and actual value table is not connected to each other. When I try connecting them, it is not working becasue it is creating ambiguity with other table (calendar).
However, I really appreciate your help.
Regards,
Nilesh Jain
- AllisonKennedy
Community Champion
You could update the Actual Value to use a measure:
Actual Value Measure = IF(ISFILTERED(Category), BLANK(), SUM(Actual Value))
Update accordingly for what Actual Value aggregation is using and add table names.
