Displaying ordinal numbers in your Power BI Smart Narratives
Sam Fischer Sam Fischer

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!

Read More