Filter related issues

[INJAINP]

Hello all,

Below is the issue that I have:

Basic filter is added to report and SELECT ALL is set to OFF but when after clearing the filter it gives ALL values.

For Example: For YearMonth Selection control is set as single select.

After clicking CLEAR SELECTION it give All values

With Select all = Off and Select Single = On, Clear filter should clear all selected values and display blank report untill new value is selected.

We are using SAP HANA direct query mode as source and latest Power BI version (December 2018)

Let me knwo if I am mising some setting or doing something wrong. Is there a solution to this issue or it will behave this way only.

Thanks

Regards

Priyanka

[v-qiuyu-msft · Accepted solution]

Hi @INJAINP,

If there is no value selected in the slicer visual, it means no filter condition is set, the report will returns data without any filter. 

For your requirement, to workaround the issue, you can create a measure with HASONEVALUE() to decide if one value is selected in the slicer. 

Measure = IF(HASONEVALUE(DimSalesTerritory[SalesTerritoryGroup]),1,BLANK())

Best Regards,
Qiuyun Yu