BLANK in Power BI
Hi,
I have created a new table in Power Bi with the dates of my Data, like in the course
But when i create a new Slicer in Power Bi in order to filter by month, it shows me (Blank)
But there is not blank data
Can i know from where this is comming?
Thanks!
Thanks!
1 answers ( 0 marked as helpful)
It is likely to do with the data, creating the month names is essentially an if statement that checks for a certain condition if it is met i.e. month number equals one then return January, etc. But if there is a null value inside the dates, Power BI would return this as blank because it doesn't know how to handle it. I would suggest you check your main date table inside the data view and see if you can find out any null values and exclude them from your table.