Forum Discussion

bschmiedeler's avatar
bschmiedeler
Frequent Visitor
6 years ago

How do I return values from a selected row in a table?

I have a data table called "Goals" in a Power BI Report. A manager is going to put in data for different Businesses (see below).   Each row will have the primary key for the business and then...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
I feel like this post is incomplete...
bschmiedeler's avatar
bschmiedeler
Frequent Visitor
6 years ago

My post got mangled, half the text and two pictures were lost. I have updated it.

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi bschmiedeler , 

    I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • bschmiedeler's avatar
      bschmiedeler
      Frequent Visitor
      6 years ago

      I am not comfortable putting any data in OneDrive. Let me try to describe the problem in a more simplified manner.

       

      My company has 3 ice cream shops. We have an SQL table that will keep track of how many cups and cones are sold this season.

       

      Name         Cups  Cones

      MidtownXY
      UpperEastZW
      SuburbanUQ

       

      I have agreed with each manager what their goals should be for this season, in the table below. This data is going to be just entered into a table in PowerBI or in an SQL table.

       

      Name          Cups  Cones

      Midtown400600
      UpperEast800780
      Suburban9001100

       

      I want to construct a PowerBI sheet where I can choose one of the three names and then construct a chart showing for each metric (Cups and Cones in this example) the goal and how close to the goal the shop is. As we go through the season I can keep track of how the shops are doing. I would like to use something like a gauge chart to do this.

       

      Any help would be greatly appreciated.