Displaying ordinal numbers in your Power BI Smart Narratives
In using the Smart Narratives feature for Power BI, I’ve found a few tricks to make your narratives even easier to read. For example, say you used Smart Narratives to show the sales performance for a given state. If that state came up 3rd best, how could you get your narrative to describe it as having the “3rd” highest selling sales, including the ‘rd’ after the 3? With a bit of DAX, you can get the right suffix showing for these ranked values, and make your Smart Narratives even smarter!