[TIPS] Set the Dynamics Maximum Value of Gauge Chart

 [TIPS] Set the Dynamics Maximum Value of Gauge Chart

Normally, the maximum value of a gauge chart is double of the showing value to make the chart looks pretty.  This maximum value is set by the system if you don't specify it.

Next, let me show you how to specify the maximum value to make it look more sensible.

Step 1 Create a Measure.

If the employee type is nothing selected, I want the maximum value to be the total amount of the people chart table. 

If any options are selected, I want the maximum value to be the total amount of the specified type of employee.

Quantity of Specified Employee =

    IF(ISBLANK(SELECTEDVALUE('People Chart'[Employee])),

        COUNTROWS(ALL('People Chart')),

        COUNTROWS(FILTER(ALL('People Chart'), SELECTEDVALUE('People Chart'[Employee]) = 'People Chart'[Employee])))

Step 2 Set the maximum value in the gauge chart format setting menu.

Finally, below will what it looks like.

N type employee total amount is 231.

There are 220 people whose availablities are between 5% and 39%.

DEMO: