Forum Discussion

SC0614's avatar
SC0614
Frequent Visitor
7 years ago

Show blank dashboard when no filter selected

Hi,

 

Is there a way to show content only when there is something filtered in the dashboard?

 

I know there is a way to use measure like following:

deposit_BLANK = if(CALCULATE(DISTINCTCOUNT(Cust_Barrie[CUST_NM]),allselected(Cust_Barrie[CUST_NM]))=1, SUM(Cust_Barrie[SB_DEP_BAL]),"")

But the measure does't work for categorical variables.

 

Tableau has this function in the filter setting. Does Power BI have a similar one?

 

Thanks,

Sherry