LASTNONBLANK and FIRSTNONBLANK are interesting DAX functions that you can use in many ways in Power BI.  However, these functions are not frequently used because of the complexities around how they calculate results. I would presume most Power BI users don’t even realize that they can utilize these functions in a variety of ways inside Power BI. 

Customers ask you to show total values in a bar-chart for all years along with each year individually.

Our Power BI Showcase has always proven how useful Power BI can be across different industries. In fact, we’ve launched 3 new showcases that give fresh insights, especially if you’re in the optical, insurance and client care sectors.

Power BI already gives us a way of applying conditional formatting on the table and matrix visuals using the default settings.

Suppose I need to give some custom color-based formatting to my cells in a table visual, how will I achieve this?

There is an easy way to create custom color formattings in Power BI using a simple measure calculation. In this article I will walk you through a step-by-step example on how to implement this in Power BI.