Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Multiple KPI/GAUGE/CARD

Hello! I have been reading solutions for multiple KPI, Gauge and Cards, but still did not got an ultimate solution. Example: During five year my target is to plant 1K trees. Year 1 200; Year 2: 2...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Anonymous ,

     

    According to your description, I did a similar test with the following reference:

    Cur_value = 
var a = YEAR(SELECTEDVALUE('Table'[Year]))
return
(a-2020)*200

     


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Anonymous ,

 

According to your description, I did a similar test with the following reference:

Cur_value = 
var a = YEAR(SELECTEDVALUE('Table'[Year]))
return
(a-2020)*200

 


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Dear Henry, 

     

    Thank you very much. It would be kind if you could let me know how i can make i dynamic.

    My target varies from one year to another. Example:

    Year 1: 6000

    Year 2: 54000

    Year 3: 52000

    Year 4: 26000

    Year 5: 12000

    Cur_value = 
var a = YEAR(SELECTEDVALUE('Table'[Year]))
return
(a-2020)*200

     

    If i am not mistaken (a-2020)*each year's target...

    I am trying, but highly appreciate if you could help me with this point.

     

    Otherwise, thanks again! 

     

    Best, 

    AK