Forum Discussion

kaboume's avatar
kaboume
Regular Visitor
2 years ago
Solved

Gauge: dynamic target value

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

Need Help

5 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    2 years ago

    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.



  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

  • kaboume's avatar
    kaboume
    Regular Visitor
    2 years ago

    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 :