Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi @Reetz
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.
Cheers
https://www.dropbox.com/home/Power%20BI?preview=Sales+Buckets.pbix
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...
Hi,
None of those links work.
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 :
Hi,
You may download my PBI file from here.
Hope this helps.
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?
Thanks again!!
Thank you. Yes, a completely different appraoch based on measures only and of course a disconnected table.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |