Forum Discussion

jracer007's avatar
jracer007
Icon for Helper IV rankHelper IV
8 years ago
Solved

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...
General Comment
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    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.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

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

  • jracer007's avatar
    jracer007
    Icon for Helper IV rankHelper IV
    8 years ago



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

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      8 years ago

      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?

      • jracer007's avatar
        jracer007
        Icon for Helper IV rankHelper IV
        8 years ago

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