Forum Discussion
Searching for 'zero entries'
Hi all,
We have project plans that have a column for "Go-live Milestones".
In this column, the default value is blank (as in empty), as not all milestones will be a Go-live, however the users change to Yes if applicable.
So, in a column of data in one project plan, there might be 2 flags, yet in another project plan there may be none.
What I'd like to do is to report on those projects without any Go-live flags in them.
In my Power BI report I have the project name and other columns, however no matter what formula I try, I cannot get a list of the projects without a Go-live milestone. I'm finding it very difficult to search for something that doesn't exist (i.e. the flag).
Sorry if I win the vague question of the day award, but can anyone offer pointers as to how I would obtain this data?
Thanks,
Rich
2 Replies
Please share the data model, sample data, sample output. Not very clear.
As of now, It seems like you can add a slicer or visual or page level filter on Milestone Date and select the milestone date as blank.
HI RichJW
You could enable "Show items with no data" for project name column of the visual.
https://docs.microsoft.com/en-us/power-bi/desktop-show-items-no-data
If not your case, please share your sample pbix file and your expected output.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Regards,
Lin
