Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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: 200;

Year 3: 200;

Year 4: 200;

Year 5: 200.

 

I wan to visualize in one dashboard by including life of project ( as maximum) and each year target and present based on actual progress how far we are from both yearly and life of project target. 

 

I'd highly appreciate if you could help with this issue.  Here is the link for similar post, but it is not robust and practical.

https://community.powerbi.com/t5/Desktop/Gauge-visual-with-multiple-targets/m-p/1258251#M553918 

 

Many thanks, 

Amriddin

 

Many thanks, 

Amriddin

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

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

vhenrykmstf_0-1633331661865.png

vhenrykmstf_1-1633331680345.png

 


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.

View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

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

vhenrykmstf_0-1633331661865.png

vhenrykmstf_1-1633331680345.png

 


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
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.