The sort by column feature of Power BI hides some potentially unwanted complexities. This blog post shows how you can avoid having to sort a column by another column while maintaining a custom sort order. Continue reading “Built-in column sort order in Power BI”
Single-letter day and month names in Power BI
Occasionally in Power BI, you may want to display day or month names as single letters to save space. This may result in duplicates because neither day nor month names are unique when you shorten them to one letter. In this blog post, I’m showing two solutions to the problem: one in DAX and one in Power Query (M language). Continue reading “Single-letter day and month names in Power BI”
Card drill through in Power BI
Drill through from cards is a common requirement in Power BI reports. While measure drill through has been possible for a while now, drill through from cards has been tricky until recently. In this blog post, I’m showing two ways to configure the card drill through. Continue reading “Card drill through in Power BI”
I’m now a Microsoft MVP!
I’m now officially a Microsoft Most Valuable Professional (MVP)! Becoming an MVP wasn’t a straight path for me: I became an MVP on the second try. Continue reading “I’m now a Microsoft MVP!”
Working with comma-separated values (CSV) in DAX
There are instances where you get a comma-separated list of keys in each row of a table, and you need to replace it with lookup values. This blog post shows two ways of addressing this situation in DAX. But first, why would you want to do it in DAX? Continue reading “Working with comma-separated values (CSV) in DAX”
Grouping text values in Power BI
The August 2020 release of Power BI Desktop includes a new Power Query function: Table.AddFuzzyClusterColumn
. This function allows you to clean, cluster, or group text values. In this blog post I’m showing an example of how it works. Continue reading “Grouping text values in Power BI”
Converting hexadecimal to decimal numbers in Power Query
On more than one occasion I saw people writing complex functions in M to convert hexadecimal numbers to decimal ones (Greg Deckler and Soheil Bakhshi, to name a few). In this blog post, I’d like to share probably the quickest way of doing it. Continue reading “Converting hexadecimal to decimal numbers in Power Query”
New DAX functions (June 2020)
Soon, 49 financial DAX functions are coming to Power BI. All the functions are available in Excel already. See the full list below. Continue reading “New DAX functions (June 2020)”
Understanding model recalculation in Power BI
Have you ever wondered why in Power BI calculated columns and calculated tables are called calculated and measures are not? That’s because in a certain sense, measures aren’t calculated, and calling them “calculated measures” is wrong. In this blog post, I’m discussing the implications of it–what recalculation in Power BI is, and how you can perform it. Continue reading “Understanding model recalculation in Power BI”
Dynamic page navigation and drillthrough
Starting in May 2020, Power BI allows you to navigate or drill through to pages by using conditional formatting. In this blog post, I’m showing how to make it work. Continue reading “Dynamic page navigation and drillthrough”