Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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 2021 | 1 |
| 02 January 2021 | 0 |
| 03 January 2021 | 3 |
| 04 January 2021 | 4 |
| 05 January 2021 | 5 |
| 06 January 2021 | 0 |
| 07 January 2021 | 7 |
| 08 January 2021 | 8 |
| 09 January 2021 | 0 |
| 10 January 2021 | 10 |
| 11 January 2021 | |
| 12 January 2021 | 12 |
| 13 January 2021 | 13 |
| 14 January 2021 | 14 |
| 15 January 2021 | 4 |
| 16 January 2021 | 16 |
| 17 January 2021 | |
| 18 January 2021 | 18 |
| 19 January 2021 | 19 |
| 20 January 2021 | 0 |
| 21 January 2021 | 21 |
| 22 January 2021 | 22 |
| 23 January 2021 | 23 |
| 24 January 2021 | 0 |
| 25 January 2021 | 25 |
| 26 January 2021 | 26 |
| 27 January 2021 | 27 |
| 28 January 2021 | 0 |
| 29 January 2021 | 29 |
| 30 January 2021 | |
| 31 January 2021 | 31 |
Hi @Anonymous ,
Is your issue solved now?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
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!
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!