The Gauge visual displays a single value within a circular arc and its progress towards a goal or target value that we specify. The Target Value is represented by a line within the arc. With our current data set, we do not have a measure that we can use to illustrate an accurate business goal, so we will have to create it. Before we set up this visual, we will need to create a new calculated measure.
Let's look at, setting up the example:
- We will be using the Total Sales measure as our value in the Gauge visual. Our target will be 10% more than the previous year's total sales, so we need to use DAX to create this measure.
- Right-click the Internet Sales table and select the New Measure option, which would bring us to the ...