Forum Discussion

Reetz's avatar
Reetz
Helper II
5 years ago
Solved

Switch function not working with a slicer

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

7 Replies