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?
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.
Actually there was not blank data on it. I checked on filters and row by row, but seems that for an unknown reason it appears. I manager how to excluded it from my report, but it is annoying to have it.