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...
Need Help
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 :

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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