Blogs / Microsoft / Power BI / Custom Visuals / Conditional formatting in Linear & Advanced Gauge Custom Visuals for Power BI

Conditional formatting in Linear & Advanced Gauge Custom Visuals for Power BI

xViz Pro Suite Visuals are completely free with all the pro features unlocked for Power BI Desktop! Leverage the full potential of xViz Suite by downloading them here.

In this blog, we will walk you through the steps to leverage condition formatting in xViz Gauges i.e. Linear & Advanced Gauge.

One of the most common methods of analyzing the health of the KPI is by using conditional formatting. xViz Gauges – linear & angular gauge comes with advanced conditional formatting options, which helps you to leverage them in a few steps.

xViz Conditional Formatting – Display options

  1. With Track background – Conditional format is applied to the background scale and value is tracked with the help of the needle
  2. Without Track background – Value of the KPI is highlighted in a single color based on defined conditional formatting similar to visual, Power BI Radial gauge
Conditional formatting in Linear & Advanced Gauge Custom Visuals for Power BI

Configuring Conditional Formatting for Gauges

There are 3 ways you can define conditional formatting using xViz Gauge

1. % of Gauge Maximum (default) – Color ranges based on percentages of Maximum value.

Conditional formatting in Linear & Advanced Gauge Custom Visuals for Power BI

2. % of Gauge Target – Color ranges are defined based on percentages of Target valueNote: This option will only show when you have a Target field assigned to the chart or configured in Additional property sheet (APS).

Conditional formatting in Linear & Advanced Gauge Custom Visuals for Power BI

3. Value – Color ranges based on a static value

Conditional formatting in Linear & Advanced Gauge Custom Visuals for Power BI

Steps to configure conditional formatting

1. Choose the xViz Gauge to add conditional formatting and select the Edit icon on the right top of the visual as shown below, to open advanced editor & configure conditional formatting

Conditional formatting in Linear & Advanced Gauge Custom Visuals for Power BI
Conditional formatting in Linear & Advanced Gauge Custom Visuals for Power BI

2. Enable conditional formatting under plot area configuration to see the xViz Linear Gauge and select the option by which you like to configure your gauge from the dropdown. As above mentioned you need a “Target value” field in order to select “% of Gauge Target”.

Conditional formatting in Linear & Advanced Gauge Custom Visuals for Power BI

3. Configure the end values in each range and see the consecutive start values gets updated automatically. You can also change your range color based on your need using color codes.

Conditional formatting in Linear & Advanced Gauge Custom Visuals for Power BI
Conditional formatting in Linear & Advanced Gauge Custom Visuals for Power BI

You can use add/delete range icon to add or delete based on your range classification.

  • The clear button can be used for ‘Revert to default’ action.
  • Disable ‘Apply to track Background’ in case you want to see the color of the KPI based on the condition rather than its position with conditional ranges.

In the below-shown example, xViz Advanced Gauge is configured to show the health of the KPI based on defined conditions.

Conditional formatting in Linear & Advanced Gauge Custom Visuals for Power BI

4. Close the Advanced editor once you are done with the changes and follow the same steps if you like to configure for a different xViz Linear/Advanced Gauge.

Conditional formatting in Linear & Advanced Gauge Custom Visuals for Power BI

To get the latest version of the custom visual, reach out to us here. You can take a look at the other advanced custom visuals by xViz here.

***

This blog has been originally published on the xViz website. Click here to visit and know more about Advanced visuals for Microsoft Power BI.


Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com


Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This!

Share this with your friends and colleagues!