Blanks in the dashboards is one of the pain and impacts the user experience. It can occur due to multiple reasons - due to data unavailability which is something is out of control of Power BI developer. One of the best practices suggest to avoid blanks with different approaches in Power BI. In this blog, we will showcase the most common approaches to tackle the blanks. This blog is mainly divided in two parts - dealing with blanks in the KPI cards and dealing with blanks in table or matrix. Let's start from the KPI cards with the updates dealing with blanks in the cards became very easy. In the new cards it is now possible to provide a separate value when a blank appears in the card. This feature is available under the formatting option of new KPI cards. Do keep in mind this feature is currently available for the new cards. In the above example we are showcasing the total sales and total sales last year in the reference. Under the highlighted section we can provide the value...
Let's discover the story behind your data. Trying to share my experience and learning in using business intelligence tools.