Join us at FabCon, March 31 – April, 2025, in Las Vegas! Register today to get the early bird discount. 

All About Power BI Metrics, A hidden Gem

It's a great external tool to generate developer documentation for our reports with a single click, and we want to have a report or document that documents the entire process from data import to Power BI, and from Power BI report authoring to delivery.

In the process, we'll have a lot of pages, measures, parameters, calculation groups, even Power Query queries, and so on. Sometimes we need something to be able to visually observe it and count this information, so the tool shared today will be able to help you!

Custom Sorting with Power BI

Custom sorting in Power BI can significantly enhance the clarity and impact of your data visualizations. However, users often encounter several challenges when setting up custom sorts. Here’s a look at some of the common hurdles and how to overcome them:

Step 1

Create a Custom Table with all the category either manually in Power Query or read from source.

Create a new column beside and provide the number in the order you want to arrange.

Step 2

Create a relationship between the column in actual table to the custom sort table.

Step 3

Create a column in Actual table with an expression.

Sort order = RELATED(CustomSortTable[Sort])

Step 4

Select the column you want to sort, and a “Column Tools” menu bar will appear at the top. Now Select the “Sort by column” and select the sort order column.

In this blog, we'll explore how to display the previous 6 months of data based on a single slicer selection in Power BI.