Forum Discussion
Helper IVFilter a visualisation to only show first 50, second 50 etc?
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?
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.
6 Replies
- BIswajit_Das
Impactful Individual
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/eu4pmjyaThanks & Regards
BxD
PowerAutomaterHi 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?
hnguy71Super User
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
Yep! it will dynamically update when the source file gets updated
