Forum Discussion
Limited Auto fill/Drill Down
Hello Community,
I came across a scenario where I want to limit my drill down/auto fill to a limited number of rows and not sure what's the most suitable way to do so.
Below is a screenshot of what I am having to illustrate further:
Would appreciate your tips and help with this.
Thank you,
Mo
Not sure what you mean by drill down. That isn't a Power Query feature. Drill through and drill down are concepts in visuals in Power BI.
Fill Down/Fill Right are Power Query features (not autofill) and they only work on null spaces.
So in the below example where I copied the TEST column, the fill only works until it gets to a non-null space, then starts over.There is no way to limit that, other than replacing some nulls with something else. You could do that in a custom column with some if/then/else logic, then do the fill down on that new column.
But to help further, I need some sample data and a clear explanation of what you are trying to accomplish.How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
1 Reply
- edhans
Community Champion
Not sure what you mean by drill down. That isn't a Power Query feature. Drill through and drill down are concepts in visuals in Power BI.
Fill Down/Fill Right are Power Query features (not autofill) and they only work on null spaces.
So in the below example where I copied the TEST column, the fill only works until it gets to a non-null space, then starts over.There is no way to limit that, other than replacing some nulls with something else. You could do that in a custom column with some if/then/else logic, then do the fill down on that new column.
But to help further, I need some sample data and a clear explanation of what you are trying to accomplish.How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.