Forum Discussion

powerbidev123's avatar
powerbidev123
Solution Sage
1 year ago
Solved

Create tooltip based measure

Hi Community,

 

I need to replicate something like below  image with the dynamic tooltip that says "You are at 30%".

 

 

Currently I have the below visual to work with 

 

 

 

Measures I used to put in the visual are

 

ScorePerCandidate = CALCULATE(SUM(postandpre[CandidateQbScore]),ALLEXCEPT(postandpre,postandpre[TestInvitationID])) --- which has value of 6
TotalPerCandidate = CALCULATE(SUM(postandpre[QbScore]),ALLEXCEPT(postandpre,postandpre[TestInvitationID])) -- which has value of 20
 
 
THanks in advance
 
 
Need Help
Show and Tell
Tips and Tricks
  • Ritaf1983's avatar
    Ritaf1983
    1 year ago

    Hi powerbidev123 ,

    It's possible to create a similar "progress path" with a waypoint using a standard bar chart combined with error bars. This approach allows for dynamic visualization without relying on a thermometer-style graph.

     

     

    If your color themes are fixed, you can also achieve this effect by incorporating image objects, as shown in the second example :

     

     

    You can also look at my other suggestion of a graph with a "race" scenario by the link :
    https://community.fabric.microsoft.com/t5/Desktop/Advice-on-best-visual-to-use-for-target-value-of-0/m-p/4238823/highlight/true#M1332280

     

    Explaining every step in detail would take some time, so I've attached a PBIX file to help you follow the logic and structure I used to create this. Feel free to explore and adapt it to your needs.

    Let me know if you have questions!

    Best regards,
    Rita

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

1 Reply

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    1 year ago

    Hi powerbidev123 ,

    It's possible to create a similar "progress path" with a waypoint using a standard bar chart combined with error bars. This approach allows for dynamic visualization without relying on a thermometer-style graph.

     

     

    If your color themes are fixed, you can also achieve this effect by incorporating image objects, as shown in the second example :

     

     

    You can also look at my other suggestion of a graph with a "race" scenario by the link :
    https://community.fabric.microsoft.com/t5/Desktop/Advice-on-best-visual-to-use-for-target-value-of-0/m-p/4238823/highlight/true#M1332280

     

    Explaining every step in detail would take some time, so I've attached a PBIX file to help you follow the logic and structure I used to create this. Feel free to explore and adapt it to your needs.

    Let me know if you have questions!

    Best regards,
    Rita

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