Gauges question

[Stymied9]

Since the default Power BI gauge does not allow you to change the fill color based on the target value being met or not, I have a question about the DialGauge and Tachometer.

Background:

I am measuring on time performance, ie: did the carrier deliver our product on time  The file I am working on has roughly 60,000 rows and 100 columns.  Within those 100 or so columns, I am using a number of them to ultimately get me to my final column, a numeric reference, 0 = on time, 1 = late, 2 = everything else that is not applicable.  I then created a measure 1- SUM of my numeric refernce column / COUNTA of my numeric reference column.

On the default gauge, I use that measure to get my on time percentage.  I can also assign different target values, 97% (.97) for Air and 90% (.90) for Ocean shipments.  So if I filter via a separate slicer, the gauge will change it's target and also change the actual on time percentage.

Question #1: Can either the Dial Gauge or Tachometer have separate targets set up and have those targets change based on a filtered slicer?  So if I have nothing or both options in the slicer chosen, it would provide an average, in this case 94% and it would include all Air and Ocean shipments.  Alternatively, if I chose only Air or Ocean, the target value would change from the 94% average to 97% or 90% respectively, also including only the applicable Air or Ocean shipments?

Question #2: 

Do I need to create an entirely different table to assign specific values for everything.  For example:

Mode       Min          Max          Target         

Air            0              100            97

Ocean      0              100            90

or would that even work?  Because I would think I need a connection between the two sheets (Air / Ocean), and the transport mode seems to be the clearest option.

Thanks in advance for your assistance.

[Anonymous]

To create a Gauge that dynamically changes colour based on the current value, use conditional formatting. You can change the Field that the colours are based under "What field Should we base this on?"

To learn how create a conditional formatted gauge, check out the YouTube demo: https://youtu.be/oEL36Fp3TU0.

[v-chuncz-msft · Accepted solution]

@Stymied9,

You may refer to the following measure.

Measure =
VAR m =
    SELECTEDVALUE ( Table2[Mode] )
RETURN
    SWITCH ( m, "Air", 97, "Ocean", 90, 94 )

[Stymied9]

I don't get the Var.m option.  I have Var.p, Var.s, Varx.p, and Varx.s.  Any suggestions?

[v-chuncz-msft]

@Stymied9,

This is just a variable.

https://www.sqlbi.com/articles/variables-in-dax/