Filter a visualisation to only show first 50, second 50 etc?

[PowerAutomater]

I have a few table visualisations of the same data, and I need table one to show the first 50 rows only, table two to show the second 50 rows only (i.e rows 51-101) and etc for the rest. The data source updates every so often with new data so I don't think it's feesible to use one of the data columns as a filter range (eg. via a date), since at any given time the amount of rows as filtered by a column does change. I'm not sure if there's some special kind of filter where you can specificy the range needed but that would be ideal.

Is there a way to do this?

[hnguy71 · Accepted solution]

Hi @PowerAutomater 

Can you share a screenshot of these "table visuals"? How many table visuals do you have on a single page / view? 

If I understood correctly, since the source data is essentially the same across these visuals, you should be able to create an index column in powerquery and then filter each of these "table visuals" by that index number.

[PowerAutomater]

Yes I think an Index column would work, let me try this now.

Will this still work when the data source is updated? Since I will be replacing the csv file periodically with a new version (same file name and columns to make sure everything else works).

[hnguy71]

Hi @PowerAutomater 

Yep! it will dynamically update when the source file gets updated

[PowerAutomater]

Just tried it and it worked, thank you.

Here is the video I followed on adding index columns for anyone who's not sure how to do it: Creating an index column for Power BI - YouTube

[BIswajit_Das]

Hello @PowerAutomater 
As per your explanation above i've tried filtering the table with a calculated column which is derived from a Date column. I've attached the PBI file link below please check if it meets your requirement.
File Link - https://ufile.io/eu4pmjya

Thanks & Regards
BxD

[PowerAutomater]

Hi @BIswajit_Das , thank you for that, I'm unfortunately not able to download any files, are you able to provide a step by step please?