Show items with no data

[ImMrAndersen]

Hi all,

I have searched far and wide for the solution to this seemingly easy issue. After i updated Power BI I am no longer able to locate the "Show items with no data" option in the Build a visual tab. Has it moved somewhere else?

Below is an example of February data where there are not sales on all dates. I would like to show all dates but have the Sum Order Intake column as blank.

Thank you in advance!

[PijushRoy · Accepted solution]

Hi @ImMrAndersen 

Right-click on Date and then you will find the "Show items with no data"

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[ImMrAndersen]

Hi Pijush, Thank you! I even tried rightclicking... But i did so on the arrow and not on the label, where there previously was a dropdown. Sometimes it's just monday i suppose.