I’m just starting out in my power BI journey and felt that I may find the answers I’m looking for on here
I have a table- let’s call it customers. And a visual showing some customer metrics in the form of a table. For each customer I have a few measures returning text options. Let’s say there’s a measure called high value that returns the text “top purchaser, average purchaser, lower purchaser” And another measure called customer age that returns the text values “New customer”,”Average customer”, and “Long term customer”
If I wanted to apply a slicer where I can filter by the result of high value or customer age (or maybe both)- like for example, I wanted to see only customers that are "top purchaser" and "new customers" what’s the best way to go about it?! I’ve watched about a hundred YouTube videos and scoured some threads but can’t find a good solution! I would love to have a filter that’s dynamic for the options returned by the measure but am fine with hard coding in the options as well as they do not change often.
I've tried making a slicer with parameters but it does not seem to work properly :(
For creating a filter (slicer) for 'Customer Age' or 'Customer Value', you could try to create 'Calculated Columns' instead of using 'Measures'.
There is a difference between Measures and Calculated Columns(or columns). Please refer this link for the detail. https://community.fabric.microsoft.com/t5/Desktop/What-is-the-difference-between-a-measure-and-calculated-column/td-p/2900507
For this case, what you could do is for each customers(rows) of 'customer' table, create 'Customer Age' and 'Customer Value' calculated columns by
Customer Value =
IF(AND(Customer[Purchase]>=0, Customer[Purchase]<100), "Lower Purchaser",
IF(AND(Customer[Purchase]>=100, Customer[Purchase]<1000), "Average Purchaser",
IF(Customer[Purchase]>=1000, "Top Purchaser",
"Other")))
Hope this is helpful.