Users of Power BI dashboards appreciate the linking of tiles to detailed reports to support further analysis. However, many users are not comfortable navigating through reports and would prefer that the dashboard itself provides all the essential information. Embedding Tooltips and conditional formatting logic into dashboard visuals are two powerful techniques to raise the insight to effort ratio mentioned in Chapter 4, Authoring Power BI Reports, while not compromising the performance or manageability of the solution.
In this recipe, a simple column chart of sales by month is enhanced with tooltip measures and conditional formatting logic. When pinned to a dashboard, the users instantly visualize a negative outcome and can hover over the bars for additional context.