Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dynamic tooltip based on values

Hello!

So, i have a problem that i'm no able to solve yet. My manager have a sheet to control projects, every project has goal and accomplished. My problem is, every project has differences types of values to measure performance.

Given the table

project | goal | accomp

s2.1 | 0,94 | 0,85
s3.2 | 34543, 43 | 353412, 34

In this example, the first value is percent and the second is $, so in table of the power bi he wants a tooltip that display the right graph depeding of the type of indicator. Somone have an idea of how can i accomplish this task?

 

thanks!

Need Help

3 Replies

  • andhiii079845's avatar
    andhiii079845
    Solution Sage
    3 years ago

    I would create separate columns for every goal type and via a measure you can transform the different columns to text for the tooltip.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      So, suposse that i have 3 columns one for $, one for just number and one for percent. Via dax measure i make a IF and change-it with dax? 

  • andhiii079845's avatar
    andhiii079845
    Solution Sage
    3 years ago

    In my personal opinion it is good for the data structure to difference the goals types. With "if" you can decide what should be shown and transform the result in _text. Let me know if you need more help. 🙂