Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
Wondering if what I'm wanting to do is possible.
Set up is, a table full of bookings (many), which links (one to many) to a table full of customers (one) and a date table (one).
I've then got a measure of number of customers (countrows), number of bookings (countrows) and TTV (sum).
What my end user wants to do use slicers to filter the customers by booking date (for example in the last year or last 2 years) and by number of bookings and TTV in that period. Without using the filters, is there a way of doing this with a slicers so the end user can see how many guests made 2 or more bookings and spent £10k or more? Or is the only way to use the visual filters, meaning I'm restricted to 1 visual or have to explain to end user to change the filter on each visual
Thanks
Mainly, you have 2 alternatives in your case :
Create a calculated table that aggregates bookings and TTV by customer and by period
Create measures that dynamically calculate the count of customers, bookings, and TTV based on the selected slicer values
Another approach is to use parameter tables as slicers, which can control the values of the measures based on user selection.
Thanks @AmiraBedh do have a guide on either method? I did start trying to go down the Parameters route, but I got stumped on how to link it to a measure.
With the calculated column route, how can I factor in the use of a date slicer into this? Or would i have to provide a fixed period, that the end user can't adjust?
Thanks
Yes if you share your data/model 😄
Heres a link to my data model https://drive.google.com/file/d/1HyWectLiAuPh5xOJ_NDHkYFW_z92yu6v/view?usp=drive_link
Hi, @LaurenceSD
Thanks @AmiraBedh . Has your issue been resolved? I can't open the link you shared, can you share it on OneDrive? Please be careful not to include any private data.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
I requested acces. Can you reshare your data ?
Thanks, yes you should have access now
Thank you - I'll anonymise it and send it over
User | Count |
---|---|
85 | |
85 | |
67 | |
61 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |