Why the Max and Min in Gauge visual + how to add Target column

[lastnn30]

Hi 

I do not understand why Gauge visual has Min and Max wells? What they are used for? I understand why we have Value and Target wells and I think that is enough. so what is the logic behind the Min and the Max? Also if you do not mind please, in this example I want to add a column to my table called "Target" and the value of each cell will be the (Sales +1000). I tried to click on the Table then Add column and then wrote  Target = Sales + 1000 but did not work, please see below, thank you so much indeed.

[lastnn30]

Thank you very much.

[mwegener · Accepted solution]

Hi @lastnn30 ,

With MIN and MAX the start and end point of the gauge can be defined. More about this can be found in the documentation.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts?WT.mc_i...

In your DAX formula the table reference is missing.

Target = SalesTable[Sales] + 1000