Dynamic tooltip based on values

[andrebmallmann]

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!

[andhiii079845]

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. 🙂

[andhiii079845]

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

[andrebmallmann]

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?