Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Slicer not to filter for specific condition on 0 and Blank values in a single column

I have a requirement. Added the data for ref. When i select Login Date as slicer and if my table contains values of 0 then i don't want 0 to be filtered out from single column. Please help me with the requirement.

 

For the below data if i add slicer of Login Date i need 0 to be display though i select slicer apart from 0 i need slicer selected values as well.

 

Appriciate your help.

 

Login Date          Count

01 January 20211
02 January 20210
03 January 20213
04 January 20214
05 January 20215
06 January 20210
07 January 20217
08 January 20218
09 January 20210
10 January 202110
11 January 2021 
12 January 202112
13 January 202113
14 January 202114
15 January 20214
16 January 202116
17 January 2021 
18 January 202118
19 January 202119
20 January 20210
21 January 202121
22 January 202122
23 January 202123
24 January 20210
25 January 202125
26 January 202126
27 January 202127
28 January 20210
29 January 202129
30 January 2021 
31 January 202131
3 REPLIES 3
v-kelly-msft
Community Support
Community Support

Hi  @Anonymous ,

 

Is your issue solved now?

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

v-kelly-msft
Community Support
Community Support

Hi @Anonymous ,

 

Could you pls provide an expected output based on your sample data?

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

daxer-almighty
Solution Sage
Solution Sage

The description is hardly comprehensible... Can you please formulate this clearly? Please note that unless people understand clearly what you want, you won't get answers. Just in case:

(1) How to Get Your Question Answered Quickly - Microsoft Power BI Community

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors