Needing Help with Date Out Not Showing Certain Criteria

[Matt_Mohawk]

Hello,

I am trying to get my report to show our Voids that we have in our project list. I am currently filtering out everything using my Date Out field but the voids do not have a date entered for that field because they were never sent out. I was wondering if there was some way to get my Voids to show up and still get my Date Out data. below is the formula that I am currently running with. I have also attached screenshots of my report so you can see what I am working with.

JOB LIST =
VAR jobList = SWITCH(TRUE(),MJS_PRICE_PW[J6STAT]="E" && MJS_PRICE_PW[J6REV#]=0,"PWE (NEW JOBS)",MJS_PRICE_PW[J6STAT]="E" && MJS_PRICE_PW[J6REV#]>0,"PWE (REV)",MJS_PRICE_PW[J6STAT]="O" && MJS_PRICE_PW[J6REV#]=0,"NEW JOBS",MJS_PRICE_PW[J6STAT]="O" && MJS_PRICE_PW[J6REV#]>0,"REV",MJS_PRICE_PW[J6STAT]="W","ON HOLD")
Return IF(AND(ISBLANK(MJS_PRICE_PW[DATE OUT]),MJS_PRICE_PW[J6STAT]="V"),"VOIDED",jobList)

Any help is appreciated.

[v-yiruan-msft]

Hi @Matt_Mohawk ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem with yours. Thank you.

Best Regards

[Matt_Mohawk]

Yes the dates that are shown are by month. The first image that was in the attachment shows that on 5/7/21 there was a void. It isn't showing up though for the month of May on the chart.

[v-yiruan-msft]

Hi @Matt_Mohawk ,

It seems that the field [JOB LIST] is a calculated column, could you please check whether it can return the value "VOIDED"  in table MJS_PRICE_PW when it fulfill the listed conditions(AND(ISBLANK(MJS_PRICE_PW[DATE OUT]),MJS_PRICE_PW[J6STAT]="V"))? Besides that, please check if there is any sync slicer or report-level filter to apply in the report pages to affect the column chart result....

Best Regards

[Matt_Mohawk · Accepted solution]

I was able to figure it out. Thank you for the help that both of you have given.

[gdarakji]

On the legend field, click the arrow and then select "Show items with no data" as per the screenshot below:

[Matt_Mohawk]

Thank you @gdarakji for your quick response. I tried doing that and it didn't work.

[gdarakji]

Are you sure there are voids on the dates shown on the chart?