Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Help finding top 12 issues in Power BI

Hi, can you help? How do I filter out the top 12 issues using a matrix in Power BI First column is product - I only want to show the top 12 products by total issue number. thanks
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • govind_021's avatar
    govind_021
    1 year ago

    Hi Anonymous 
    can you clarify whether you want to show top 12 products or top 12 issues.
    you can use Top N filter from the filter pane.
    1) select matrix 
    2) Open filter pane
    3) In Product filed , select filter type to Top N and in box below enter 12 and 
    in by value section drag total issue number count and hit the apply button.

    Best Regards
    Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
    Let's Connect
    Linkdin - www.linkedin.com/in/govind-sapkade-845104225
    Youtube - http://www.youtube.com/@govind_dataanalyst


govind_021's avatar
govind_021
Icon for Super User rankSuper User
1 year ago

Hi Anonymous 
can you clarify whether you want to show top 12 products or top 12 issues.
you can use Top N filter from the filter pane.
1) select matrix 
2) Open filter pane
3) In Product filed , select filter type to Top N and in box below enter 12 and 
in by value section drag total issue number count and hit the apply button.

Best Regards
Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
Let's Connect
Linkdin - www.linkedin.com/in/govind-sapkade-845104225
Youtube - http://www.youtube.com/@govind_dataanalyst