Forum Discussion

dlgardo's avatar
dlgardo
Regular Visitor
9 years ago

Graph showing Exchange user activity

I want to be able to display a graph showing email users based on their activity.  So, I have the following columns:

 

Username

Send actions

Receive actions

 

I can display a graph showing users with the actions data, but I want to be able to filter that by top 100, or whatever.

 

Any suggestions?

Need Help

2 Replies

  • dlgardo's avatar
    dlgardo
    Regular Visitor
    9 years ago

    Since I'm just learning PowerBI, I've discovered the very easy solution, which is to use the Top N filter.  That said, now, if I want to toggle (a Slicer?) between two different values, i.e. top 100 by Item count or Storage used, what would I do?

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi dlgardo,

     

    The Top N filter in filter panes can be applied based on one measure value. If you want to select Top N values based on more than one filed value, you can create a table use TOPN() function to order by two fields.

     

    If you still have problem, please share some sample data and desired results so that we can test it.

     

    Best Regards,
    Qiuyun Yu