Power BI - Hot & Cold

The Hot & Cold views compare the selected metric across two time periods to identify positive or negative trends.

  • Hot: The selected metric increased between the two periods.

{44558C87-7119-499E-8B9D-911BC41E47FB}-20260512-214248.png
  • Cold: The selected metric decreased between the two periods.

{F0967165-43BB-4DC4-A57F-532FED502B97}-20260512-214758.png
  • The Hot & Cold views show changes in Sales, Cost of Sales, Gross Profit, or Qty Sold between two selected time periods.
    See the Measure selection on the right.

  • The data can be grouped by Country, State, City, Customer, Doc No, Item, Salesperson, or Warehouse.
    See the Dimension selection on the right.

PBI - Hot and Cold.gif
  • The data sorts in descending value of the measure; highest to lowest for the top number or records you choose.
    See the Top N selection on the right.

  • The data can be filtered by Branch, Item Category, and Salesperson.
    See the Filter selections on the right.

PBI - Hot and Cold1.gif