Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone,
I'm looking for some help on displaying data from one dataset across two tables.
I currently have a dataset that displays results in a table on my dashboard. The results can be anywhere from 1 to 50 rows worth of information. As this will be displayed on a TV in a production facility, I would like to show all potential values on one screen without the need to scroll (as the TV/PC will not have any input devices for the users) and my idea was to display the results across two visual tables.
The first table would show rows 1-25 of the results, and the second table would show rows 26-50. The image attached is how I would like the data to be shown (as you can see it displays the earliest "PickDate" value at the top of the first table as 02/08/18 and the earliest "PickDate" value at the top of the second table as 28/08/18, as the first table only shows up to the 27th at the bottom).
The values in the table will change as the source location is updated and lines are removed when they are no longer required, so in theory it needs to be a dynamic way of showing the data. For example, If there are only 30 rows available in the dataset I would like it to show 25 in the first table and then 5 in the second table.
I've been racking my brains but cannot seem to see how this would be possible.
Any assistance is greatly appreciated!
Solved! Go to Solution.
i'm not sure but try to use filter top N by column pickdate
for example
I am seeing amazing exicited people who write such a detail answers by taking pain and investing valuable time to reply, whereas some are just opposite just inserting links for spamming, marvelous Edu Birdie
Thanks for sharing! I have a project for Edu Birdie where I need to have the same results in two tables.
Hi @Stampers,
As the way @petrovnikitamai shared, the top N function should work well.
Regards,
Frank
Hi @Stampers,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
i'm not sure but try to use filter top N by column pickdate
for example
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |