Forum Discussion

Brett007's avatar
Brett007
Helper III
5 years ago

Adding a Table for Yearly Target Values

PBi Report Target Values

 

I have 3 Locations China Germany and USA

I have 5 Product Lines Product A, Product B, Product C, Product D, Product E

 

A, B, C Manufactured in China

A, B, D Manufactured in Germany

C, D, E Manufactured in USA

 

Target Values are different for each Product Line, and Location combination

 

Here is the part that I am stuck on.  

The Total Team in each Location has a goal called "Central" (All Product Lines, but it is not an avg or sum of Target Values)

 

I can filter for all of the results and display the results from a data input table that I created, but I don't know how to show "Central".  How do I associate "Central" as representing all of the Product lines when this option is not in any associated columns.  

 

TLDR: End Goal - Click on a Chiclet Slicer for Location and a separate Chicklet slicer for Product Line, and receieve the target Value in a "Card" visualization.  The Same filters will filter other tables based on the same attributes, but do not know what to do with "Central".

 

Thank you.

2 Replies

  • Brett007 , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • Brett007's avatar
      Brett007
      Helper III

      I added a file at the very top.  Thank you.