Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Show items with no data

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!

Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi Anonymous 

    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

2 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi Anonymous 

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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.