cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
INJAINP
Frequent Visitor

Filter related issues

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Filter related issues

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())

 

 

w1.PNGw2.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support
Community Support

Re: Filter related issues

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())

 

 

w1.PNGw2.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors