The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

BLANK in Power BI

BLANK in Power BI

Super Learner
0
Votes
1
Answer

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!

1 Answer

365 Team
0
Votes

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.

5 months
×
LAST CHANCE
Ready to Learn Data Science?
50% OFF