cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jracer007 Member
Member

Gauge with dynamic target

Hello community,

Today I wanted to request your help to build a gauge with the following characteristics:

-The target value 'MITIGOAPP v1' must be equal to the one in the current month. Example: in December the value should be 201,515.
-The current value must be the last of a column that is in another data source.

Thank you.

 

MAUMITIGOAPP v1
Jan-16139,216
Feb-16145,802
Mar-16149,296
Apr-16152,542
May-16155,825
Jun-16159,176
Jul-16162,598
Aug-16166,094
Sep-16169,665
Oct-16173,313
Nov-16177,039
Dec-16180,845
Jan-17171,073
Feb-17173,639
Mar-17176,244
Apr-17178,887
May-17181,571
Jun-17184,294
Jul-17187,059
Aug-17189,864
Sep-17192,712
Oct-17195,603
Nov-17198,537
Dec-17201,515
Jan-18 
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Gauge with dynamic target

here is link to pbix file, i did few things which I can explain, basically converted your "MAU" to "Month Date" for relative filtering as 1st date of the month, you can see this in power query and from there it was all easy.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






16 REPLIES 16
Super User
Super User

Re: Gauge with dynamic target

@jracer007 what is your other data source? Can you give full picture of your data model and any relation tables have?




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






jracer007 Member
Member

Re: Gauge with dynamic target

Opera Instantánea_2017-12-07_134809_docs.google.com.png

The last value of column K is the data that I want to be displayed as the current value.

Super User
Super User

Re: Gauge with dynamic target

Still not very clear but i guess you are saying if nov 2017 is selected, you want to show last value from Col K from nov 2017 w hich will be 192379 as target and sum of col E will be total value will be actual, correct?

 

And in case dec2017, target value will be 85085 and so on...

 

is this correct understanding?




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






jracer007 Member
Member

Re: Gauge with dynamic target

no, the objective value is taken from the first source of data that I showed.

Super User
Super User

Re: Gauge with dynamic target

oh ok, from your data sample (1st picture) there is no data for each day of nov, 2017 but in your 2nd image, you have col K with values.

 

Anyhow, you can use lookup function to get the value from your target or if these tables are related then you can use related function.

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






jracer007 Member
Member

Re: Gauge with dynamic target

are not related, look at this example of how it should be:
Opera Instantánea_2017-12-07_140818_app.klipfolio.com.png
Could you help me with the formulas? I'm new to Power BI

Super User
Super User

Re: Gauge with dynamic target

No problem, can you share your data using google drive in excel and i will put together somethign from you. Just send me basic data and mask any sensitive data.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






Super User
Super User

Re: Gauge with dynamic target

@jracer007 is this how your data is? If that is the case then on yoru gauge visual just put "Target" column in Target value and actual in value




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin