Forum Discussion
Do not show chart when value is below certain threshold
Hi,
I have report:
In the breakdown chart (middle), I have some filters applied. Also some other slicers impacts the chart.
I want to hide the breakdown chart when my total FTE value is below e.g. 5.
So in above case, if I select Job Level 1 and 7 from the slicer, the breakdown chart will be hidden.
I have tried:
Measure =
IF(
CALCULATE(
[FTE]
,REMOVEFILTERS('1'[JobLevel])
)
> Privacy_ShowMoreThanX[Privacy_ShowMoreThanX Value]
,[FTE]
,0
)
But does not seem to work.
2 Replies
- amitchandak
Super User
Anonymous , Use a visual level filter on measure [FTE] > 5
amitchandak , this filters out individual bars below 5, but I want to hide the whole chart if the total is below x. Tried with 1, and the last two bars are gone:
