The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, Am working on a PBI project which reports on data for an online commercial repairs system.
I have a "completedDate" field which the user wants to have on their report. As most of the data, repairs, are is NOT completed, they also want to be able to select BLANK value in the "completedDate" slicer.
Ideally what I would want to see is the between dates they are used to, but is there an option/something I can set up to allow the user to select a blank date?
Thanks
Andrew
Thanks Michael, I've gone with what you suggested. Was hoping there was something else I could do but I guess it's fine.
Cheers
Andrew
Hi @andrewjmdata ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
Hi @andrewjmdata ,
Normally when you put a field with blank values in a slicer then blank should be an available option.
Can you please share a picture of your data model / table as well as a picture of a slicer with the completion date in it?
Which type of slicer to you use? Did you set the slicer on dropdown or something else?
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
User | Count |
---|---|
80 | |
74 | |
42 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |