Show days with zero value

[PamelaS]

Good morning,

I could use a hint.

I have a data table with the hours worked by each employee

I tried to visualize the totals for each day for each dependant, but I noticed that it does not allow me to visualize the days where there are no hours worked.

Do you know how to solve this problem?

Thank you very much

[PamelaS]

Thank you all,

I tried to use the function "show item with no data", but as @Xiaoxin Sheng said, unfortunately it doesn't work.

Thank you very much for your help

Pamela

[EricHulshof]

You give up to easily. Can you provide some sample data of your structure so i can show you how to do this?

[PamelaS]

Hi @EricHulshof 

I'd like to see in the table below even the days with zero hours worked...

Thanks a lot

Pamela

[EricHulshof]

When i press show items with no data it does work. it does show me all the dates in my date table tho. So you have to filter that somehow.

[v-shex-msft · Accepted solution]

Hi @PamelaS,

I'm not so sure what visual you use, can you please explain more detail? 
If you are working with table visual, you can right-click on its fields and choose 'do not summarize' and 'show item with no data' options to force display whole items.

If you are working with charts, it is impossible to display records with blank/zero values, they will be summarized based on category fields. (Current you can't ignore/cancel this operation)

Regards,

Xiaoxin Sheng

[EricHulshof]

here you go 🙂

[MartynRamsden]

Hi @PamelaS 

Click on your table and then, in the Visualizations pane, right click on your 'Date' field and select 'Show items with no data'.

Best regards,
Martyn

If I answered your question, please help others by accepting it as a solution.