How to Always Include Blank Dates in Power BI #Q&A

Today we are answering a question that came in from one of our Learn Power BI Family members, Venkatesh.

===Most Popular Playlists===

⚡Power On!⚡
-Avi Singh

#PowerBI #PowerBIHowTo #PowerBIPro

[benignoalbio]

i have a different question, I'm a beginner on this thing, I tried to make my first visualization on my AHT report, However, on my Data, weekends has no data since it is an OFF WORK for us, however, when I tried making the Stacked Column chart, the weekend date will always show as blank.

[yit]

how do you handle the last scenario you mentioned, I have exact same requirement where in the values are getting filtered out

[didierterrien]

Hi Avi,
Great video!
Does v2 work if blank is also selected in the slicer?

[mikeliverpool]

Hi, I'm trying to do this with a map so that points without dates can stay plotted the whole time. I run into errors with the Calculate function, would there be any way around this?

[rakeshsatravada]

What if we have two date fields with NULL values?

[riazuddin]

How can i replace null value to blank in a date column, if I try the same using replace values then it asks me to provide a date

[anshumansinharoy]

Hi Avi, I have a data where the date appears in both UK & US formats in a single column. I am not been able to fix the error. Kindly help me out with that.

[akhilannan]

The last scenario which was mentioned in the video could be potentially achieved by creating one more Date table with an inactive relationship to the Calendar table, and taking the slicer from this new Date table and some DAX magic in measures (Userelationship, etc).

[AlessandroSilva-dlvq]

Olá boa noite obrigado pelas dicas.
Vc teria algo parecido de clientes sem vendas com filtros de períodos e que mostrasse esses clientes não Atendidos no mapas?