Forum Discussion

Jespersandren's avatar
Jespersandren
Frequent Visitor
9 years ago

Target/Goal - How to? Tips & Tricks?

Hi,   Im new to Power BI and i have been trying to use Power BI and figure out how visuals work, DAX codes, different kind of functionalities etc etc. Now im trying to figure out whats the best way...
Jespersandren's avatar
Jespersandren
Frequent Visitor
9 years ago

Thanks, looked into that and your right thats one way.

Im interested in goals/target management in Power BI, hows your setup?

  • Jespersandren's avatar
    Jespersandren
    Frequent Visitor
    9 years ago

    Thanks for the post!

    Im more interested in what kind of corporate setup you have around targets/goals in Power BI, how you have managed the setup in Power BI, if you understand what i mean?

     

    Best Regards

    Jesper

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      9 years ago

      Hi Jespersandren,

       

      Honestly I can't understand your question very well. Would you please share detail information about your requirement? If possible, some screenshots are better.

       

      Best Regards,
      Qiuyun Yu

      • Jespersandren's avatar
        Jespersandren
        Frequent Visitor
        9 years ago

        Thanks for being sincere, its quite hard to explain but let me try.

        We as a company are about move our entire KPI to Power BI and to this im appointed to make this happen. Im new to the system and im trying to figure out how it works, how to make the best setup to satisfy everyones needs and there are three things that i want to know more about and it is:

        1. Hows your or whats the best setup regarding all the tables? I know and i guess that in the end there are alot of tables and to have a nice structure among these is a great thing.

        2. Amongst all the tables there are a few thing everything has in common (at least for us and now :) ) and it is Location and Date. Unfortunatly our systems provide different variations of data around Date and Terminal (eg. SWE Gothenburg instead of Gothenburg) and to use this information i need a separate table for all our Locations and manage the Locations with relationsships. My question here is, im i doing this right or is it the right way? How do you do?

        3. In all our KPI's we have targets/goals, how do you manage this in Power BI? Not all Visuals have properties for Targets/goals (like the gauge visual), should you then setup your PBIX so there is only visuals like the gauge visual? Googled this and found a guy using goals in a separate table and using values like 1, 2 and 3 and have linked an arrow picture to the specific values and when a goal or target hit this value an arrow appears.

         

        I hope you understand more, this is not a problem, i just want to make a great setup from the beginning.

        Best Regards

        Jesper