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.
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.
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |