Have been trying to figure this out, watched videos etc, but still can't get this to work.
I have a Customer Orders Table for Jan & Feb 2020 and need to annualize Customer Sales and place them in dollar buckets. Then using a slicer with those buckets, display just those customers and their annualized sales that fall into the sales bucket selected. In the example below, selecting 500-999 should only display customer 4 in the Sales Buckets Table. Thanks in advance!!!!!
See attached Power BI. https://www.dropbox.com/home/Power%20BI?preview=Sales+Buckets.pbix
Solved! Go to Solution.
Link is not working. Must be missing something
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Here is the link again. Clicking on it says that you must download it first.
Or possibly via this link using my shared drive. https://stryker-my.sharepoint.com/:u:/r/personal/rita_stump_stryker_com/Documents/Power%20BI/Power%2...
sorry. not sure why my links are not working. Hoping these help.
I have 2 Tables: Customer Sales & Sales Buckets
|Customer Sales Table |
This is an image of my fields and measures:
my 4 measures are :
This is Great!!!! Thank you! Just curious, I thought I had to use the Switch function to make this work. Is this just a different approach?
Thank you. Yes, a completely different appraoch based on measures only and of course a disconnected table.
Check out new user group experience and if you are a leader please create your group
Click here to read more about the April 2021 Updates!
May the fourth be with you, join us online!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.