Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am trying to create a table in Power BI that shows me the sales category in the rows field which then drills down into the customers within those category's and then only shows certain customers with all the rest being the balancing figure. I have the table working but not sure on how to do the selection.
Same category's might have 10 customers that we want to track currently while others might only have 2 so cannot do a top 10 for example.
Also, the customers will not always be the same. Next week we might want to track other customers so the selection should be easy to change.
What is the best way to achieve this in Power BI for a newbie.
Thanks
Hi @KenHardwick
I'm afraid that i cannot full understand that. Did you use slicer to filter the special customers and then change the total value? Below is a post for your reference. If it is not your case, could you share some data sample and expected output?
How to Get Your Question Answered Quickly
Regards,
Cherie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |