Knowledge Center

19 Aug, 2020

Power BI July 2020 Update – Gradient Legend

Posted on 19 Aug, 2020 by Admin, Posted in Dynamics 365 Power BI

Power BI July 2020 Update – Gradient Legend Blogs

Power BI July 2020 Update – Gradient Legend


  • Sometimes, when you conditionally format data colors on a visual it can be hard for report viewers to know on what basis the data is formatted.
  • With July 2020 update, you can now include a legend for data colors that have been conditionally formatted by color scale. This legend can help clarify the meaning of the colors in a visual to report viewers.

Conditionally Format The Data And Enable Gradient Legend:

  • Go to Data Colors from the formatting pane and open the conditional formatting dialog.

  • Use this dialog to set a new rule to format your data along with a color scale:

  • You can now see that the data in the visual is now formatted by the colors according to the rules you have set in the conditional format dialog.

  • This will enable the Legend card in the formatting pane. You can enable the gradient legend by toggling it on, then format the legend as desired.

  • And now you can see the legend and know how the data in the visual is formatted.

Note: Please note that you cannot both conditionally format your data colors and split your data using the Legend field as well. This is because the Legend field already colors your data by category.

The gradient legend feature is enabled for bar, column, and scatter charts:

  • Stacked bar chart
  • Stacked column chart
  • Clustered bar chart
  • Clustered column chart
  • 100% stacked bar chart
  • 100% stacked column chart
  • Scatter chart


This is a Required Field


Recent Updates

11 Jun, 2024

How to create a routing rule set to route cases in Dynamics 365

In this blog we will discuss how to create a routing rule to automatically route the cases to queue in…

06 Jun, 2024

Restoring Deleted Records in Dataverse Tables

In this blog post, I will be discussing how we can restore the deleted records from any table in Dataverse.…

15 May, 2024

Associated Grid Control Component in Dataverse

The Associated Grid Control enables us to improve the simplicity and readability of forms by displaying related record details across…