Forum Discussion

Idkpowerbi's avatar
Idkpowerbi
Helper I
3 years ago
Solved

Editing input sheet for dateseries with nulll cells

I have an excel date series data just like( many years of data). You can see that each date has multiple rows of reasons and time attributed to it. Is there a way to modify this data so that I ...
Need Help
  • Kishore_KVN's avatar
    Kishore_KVN
    3 years ago

    Hello Idkpowerbi ,

    After importing data into Power BI. In Power Query Editor select date column and under transform option you can see fill down as per below screenshot. If you click on fill down then the empty cells will be filled and then you can use the same column in your slicers. 

     

    If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

Kishore_KVN's avatar
Kishore_KVN
Solution Sage
3 years ago

Hello Idkpowerbi ,

After importing data into Power BI. In Power Query Editor select date column and under transform option you can see fill down as per below screenshot. If you click on fill down then the empty cells will be filled and then you can use the same column in your slicers. 

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!