Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
Not sure if this is possible, but would be a cool if it is.
I basically have a cohort table comparing when a customer first appears and how often they continue to purchase from us.
The problem is i would like to multiple possible cohort dimensions, say by week, by month, by quarter, by year etc.
I created a field parameter to allow the user to select which dimension of cohort they want to compare. My issue is I need two field parameters, one for each axis of the table (when the customer first appears and when the customer buys), since these are two complete seperate.
Is there a way to "link" these to field parameters, so you would only need to select Quarters in one selection and not in both?
Solved! Go to Solution.
Worked like a charm with a one-to-many relationship only filtering one way. Added an additional column on each table with names (year,quarter,month,week etc.), not sure if that was required though 🙂
That's great! Thank you for your feedback 🙂
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |