Inforiver

Upcoming webinar on 'Inforiver Charts : The fastest way to deliver stories in Power BI', Aug 29th , Monday, 10.30 AM CST.    Register Now

Custom sort / reorder rows & columns in Power BI

by Inforiver | Nov 05, 2021 | ,

Till date, the options to perform a custom sort or reorder of rows (or columns) in Power BI have been limited. This is the case with many other BI tools as well.

One common Power BI workaround requires you to modify your data model. You will need to create a separate column that defines a custom sort key for each category. The Power BI table/matrix then uses this sort key to present the items in the appropriate order. While this approach works as intended, you unnecessarily end up creating unwanted dependencies. E.g., if your company launches a new product, you will have to update the table to define its sort position.

With Inforiver, you can just click and drag rows or columns to order the categories the way you want. You do not have to do data-model level changes anymore. This helps your users focus more on building reports that you need and the way you want, without having to spend time learning or mastering Power BI workarounds.

* * *

With the custom sort / reorder feature, you can build formatted financial statements such as income statement, balance sheet and statement of cash flows with ease. You can also insert calculated rows or columns and move them around.

Check out the (relatively) elaborate video on how to build a P&L statement using Inforiver in less than five minutes. Note that Inforiver delivers a wide array of features including custom sort order of rows using a no-code user-friendly experience.

Related Power BI Ideas:  Reorder columns in a matrix/table 


Inforiver Logo
IBCS Certified
Power BI certified
About Inforiver!

Inforiver drives business productivity and business performance with faster time to insights inside Power BI through an intuitive no-code experience. The product is developed by Lumel Technologies (formerly Visual BI), which has a decade of experience in building add-on solutions on top of BI platforms (SAP BI and Power BI) with our suite of innovative products such as ValQ, xViz, and BI Hub
Headquarters
5920 Windhaven Pkwy, #130
Plano TX 75093
ValQ
xViz
BI Hub
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram