Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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
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?
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |