Forum Discussion

BogdanP's avatar
BogdanP
Frequent Visitor
10 years ago
Solved

Setting up static TopN filter

Hello everyone!   I have standard transactions table and a date table. Transactions table contains info on various producers and their output. I created a simple measure to calculate their average ...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    10 years ago

    BogdanP

     

    In this scenario, I think we can first create a new TOPN table for 2016. 2016 Topn Producer Eng will be in this table. Then create a measure to calculate the volumes for each Producer Eng in a specific year (which will be on the X-Axis). At last, drag this volumes measure into Value field, the column chart will always show the volumes of 2016 topn producer eng for each year.

     

    Best Regards,

    Herbert

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
10 years ago

BogdanP

 

Could you please provide some more information like columns in your each table and relationship between tables?

 

Best Regards,

Herbert

BogdanP's avatar
BogdanP
Frequent Visitor
10 years ago

v-haibl-msft

 

Sure. Here are the relationships:

 

 And there is a full list of "Volumes" table fields:

 

 In this analysis I am also considering only the values where dimension = "mln l". Table GroupsVolume do not take any part in currently discussed visualizations.

 

Thank you in advance.

 

Best Regards, 

Bogdan

 

 

 

 

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    10 years ago

    BogdanP

     

    In this scenario, I think we can first create a new TOPN table for 2016. 2016 Topn Producer Eng will be in this table. Then create a measure to calculate the volumes for each Producer Eng in a specific year (which will be on the X-Axis). At last, drag this volumes measure into Value field, the column chart will always show the volumes of 2016 topn producer eng for each year.

     

    Best Regards,

    Herbert