Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
98 | |
87 | |
35 | |
35 |
User | Count |
---|---|
152 | |
98 | |
81 | |
61 | |
55 |