Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Set Gauge Max/Min/Target with Measure or Field

    Vote (10) Share
    Diego Vega's profile image

    Diego Vega on 30 Jun 2017 13:15:00

    Allow to use Measures as Max/Min/Target in Gauge Visualization, right now I can use static values, but I have a sales target which changes everymonth, It would be great to use a Field or Mesause to set that target.

    Comments (1)
    Diego Vega's profile image Profile Picture

    Jack Wells on 05 Jul 2020 23:20:14

    RE: Set Gauge Max/Min/Target with Measure or Field

    You can already do this, you might need to create a measure though (e.g. This Months Sales).

    I'm doing exactly this with measures based on TODAY () as a reference point that is making week to date sales, a target of the equivalent WTD sales last week and then a max gauge of last week's total sales.