Matrix Magic - Paginated Table and Custom Sorting - Crypto Currency

Question

I attempted to recreate a Crypto Insights dashboard in Power BI, using M language to connect and transform data from the CoinGecko API.

The idea behind this visual wasn’t just to show crypto metrics, it was to experiment with table pagination, row display control, and custom sorting logic.

Even though Power BI’s native table already supports sorting, this exercise was about exploring how far we can push customization and interactivity for storytelling and user experience.

Key aspects:
✅Pagination for better navigation
✅Dynamic control of rows displayed
✅Custom sorting approach for specific business logic

This is not a polished solution — there’s plenty of room for improvement in terms of visual best practices, dynamic behavior, and UI refinements. The intent was to demonstrate opportunities for prototyping and experimenting inside Power BI.

Feedback and suggestions for enhancements are welcome!

tononfelipe · Answer

Hello,&nbsp;Congratulations on the excellent work!&nbsp;One thing I noticed is that the page segmenter continues to 20 even when the rows end before that.&nbsp;I took the liberty of making a brief adjustment by applying a visual filter to only show the selection of pages that contain data.If it helps, I used the following measure:Filter Page = IF(&nbsp; &nbsp; [Value # items rows] &lt;= [Total Pages],&nbsp; &nbsp; 1,&nbsp; &nbsp; 0)&nbsp;&nbsp;Thank you!&nbsp;

gusbavia · Answer

PauloGrijo&nbsp;Love it! Well done&nbsp;

pb_amk · Answer

It’s one of the cleanest and most informative report pages I’ve ever seen. I’m truly inspired by the design. Thank you for sharing the PBIX file—it's incredibly helpful for applying your solution to my own projects.

mariazubillaga · Answer

PauloGrijo&nbsp;Thank you so much for sharing, this is awesome ❤️

mariazubillaga · Answer

Amazing work 👏 👏 👏&nbsp;