Gauge: dynamic target value

[kaboume]

Good morning,

On my Power BI report, I have a gauge on the dashboard indicating the turnover achieved over the year.

I would like the target value of this gauge to be dependent on the year being viewed. So I created a table called “Objectives” with two columns: the year and the amount of desired turnover.

On the other hand, I do not see how to define in the gauge as a target value: the recovery in the "Objectives" table of the amount of turnover corresponding to the current year.

Thank you in advance for your

[kaboume]

Good morning,
Thank you very much for taking the time to respond to me.
Here is my gauge.
I created a measure like this:

Objectif En cous =
CALCULATE (
SUM ( Objectifs[Montant] ),
FILTER ( Objectifs, Objectifs[Année] = SELECTEDVALUE(Dates[Année] )
))

But when I click on the year 2023, I have the objective 4000000 which is displayed in the gauge when I should have 3500000!

Objectifs Table :

[Anonymous · Accepted solution]

Hi, @kaboume 

You can try this.

Measures:

Objectif En cous =
CALCULATE (
    SUM ( Objectifs[Montant] ),
    FILTER ( Objectifs, Objectifs[Année] = SELECTEDVALUE ( Dates[Année] ) )
)

If this does not work, could you please share complete data(Dates table) without sensitive information and expected output.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Anonymous]

Hi, @kaboume 

May I ask if this is the expected output you are looking for? Based on your description, I have created a measure to achieve the effect you are looking for. Following picture shows the effect of the display.

Measures:

SelectedYearSales =

VAR _selectedYearSales =

    CALCULATE (

        SUM ( 'Sales'[Sales] ),

        FILTER ( 'Sales', 'Sales'[Year] IN VALUES ( 'Year'[Year] ) )

    )

RETURN

    IF ( ISFILTERED ( 'Year'[Year] ), _selectedYearSales, 0 )

If this does not work, could you please share some sample data without sensitive information and expected output.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Anonymous]

That should work if you have a field in one of the Value wells and Turnover in the Target value well.

[Fowmy]

@kaboume 

Can you share some sample data with the desired output to have a clear understanding of your question?
You can either paste your data in the reply box or save it in OneDrive, Google Drive, or any other cloud-sharing platform and share the link here.