Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Top N combine with visual filter

I'd like to have a chart shows top 10 product growth rate (by sold quantity) for products having monthly sold quantity over certain number. It seems like it's picking the top 10 first and then filter...
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
9 years ago

I created a calculated measure for growth rate instead of a adding a calcuated column. This is mainly because the end users might filter by different time period or product category. I just thought the TOP N should be the last filter to apply to the visual if there are miltiple filters existed for the same visual. Just wondering if there is way to specify the filter sequence to get the correct outcome.

 

wenchi

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

 

Please provide some sample data, I need to know your table structure and report design. Also, please tell me how you generate the measure for product growth rate and what is the quantity criteria.

 

Best regards,
Yuliana Gu