How to Always Include Blank Dates in Power BI

Today we are answering a question that came in from one of our Learn Power BI Family members, Venkatesh.
👉 Download Power BI File in Video at web.learnpowerbi.com/download/
👉 FREE Power BI Step-by-Step Tutorial web.learnpowerbi.com/tutorial
👉 Download Accompanying PBIX Files for Video at web.learnpowerbi.com/download/
✅ Subscribe to always get my latest videos: goo.gl/P79Hcr
🔴 Join me Fridays for Talk Power BI LIVE kzbin.infolive
👪 Join our Talk Power BI Insider's Club www.TalkPowerBI.com
===Most Popular Playlists===
• Power BI Beginner Tutorial: goo.gl/KRRkPG
• Ultimate Calendar: goo.gl/pyki4K
• Power BI Data Modeling and more: goo.gl/WNtJFv
⚡Power On!⚡
-Avi Singh
www.LearnPowerBI.com
www.AviSing.com
#PowerBI #PowerBIHowTo #PowerBIPro

[@benignoalbio674]

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.

[@didierterrien6933]

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

[@y3it877]

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

[@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).

[@mikeliverpool98]

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?

[@anshumansinharoy6860]

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.

[@riazuddin7493]

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

[@nitinrungta3320]

also if someone is replying, i want to know, instead of a null how can i replace it with last non-blank value of a Previous Date. Thanks in advance

[@rakeshsatravada8138]

What if we have two date fields with NULL values?

[@AlessandroSilva-dl3vq]

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?

[@PowerBIPro]

Hey Alessandro, So it sounds like (based on Google Translate) that you are looking either for - Customers who did not buy - or maybe Customers who bought much less this year than last year (big drop in Year over Year sales) Yup this is easy to figure out. For me to help you, I would request that you join me in one of my LIVE TalkPowerBI shows (link below). If you join, mention in that chat that you had asked this question in KZbin Comments earlier :-) As for showing them on a map... That's easy too as long as of course you have the Customer Address stored. You can just use one of the map visuals. ⚡Power On!⚡ / Avi ★ Power BI Beginner Tutorial: kzbin.info/aero/PL7GQQXV5Z8ef2SjkDpLnvsz7TAQjlzlpO ★ ★ Subscribe and Join me LIVE for Talk Power BI Fridays kzbin.infolive ★

[@AlessandroSilva-dl3vq]

@@PowerBIPro what time will it be? já estou inscrito

[@AlessandroSilva-dl3vq]

@@PowerBIPro I'll try to keep up, because English classes do not understand everything yet, it makes it difficult to understand

[@PowerBIPro]

Don't worry about English, we can have you share your screen and may be show around your Power BI Model and what you are trying to do. I am sure we can figure it out. "Data" can be our common language :-) As for the time, it is Friday 9AM Pacific Time (GMT - 8). If you go to kzbin.infolive and wait for a few seconds, it should show you the time in the corner in your own local time. You can also join the TalkPowerBI Insider's Club at www.TalkPowerBI.com that way you would also get an email reminder. Talk to you soon. Power On! / Avi

[@AlessandroSilva-dl3vq]

@@PowerBIPro ok muito Obrigado pela ajuda to estudando aqui as aulas do seu canal.