Hide a complete table if any record has value <N

[Anonymous]

Hello All,

I am trying to hide a table visual  based on a condition which is if any record from the table visual has less than 5 value then all records/table from it should be hidden.

Sample data : 

Dim Table : Dim_Age_group
Age_group_skey   Age_group_name
1                           Under 25

2                           25-35

3                           35-45

Fact table  contains columns : Age_group_skey and  headcount_ind

The table visual which I am creating with help of above two tables is like below :

Headcount = Sum(Headcount_ind)
Age_Headcount Table :   
Age_group_name     Headcount

Under 25                   60          

25-35                         2000

35-45                         4

So, Basically I want to hide all records/table visual as this table has 1 record for which the value is <5.

Looking forward for your suggestions.
Thank you

Regrads,

Prabha

[Anonymous · Accepted solution]

Hi @Anonymous ,

To my knowledge, there is no option to hide visuals based on conditions.

Ideas similar with what you expect have been submitted in the following links, please vote them up and you can add comments.Hopes Power Bi will implement this in nearby future.

Visibilty (Hide an Item)

ability to show/hide visuals based on conditionals

My workaround is use a flag measure for filter to "show" or "hide" rows:

Count of less than 5 = 
var _t= SUMMARIZE(ALL('Dim_Age_group'),[Age_group_name],"Flag",IF([Headcount]<5,1,0))
return SUMX(_t ,[Flag])

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.