Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
I have a slider for date range selection and there are 4 rows of possible data, 1 for each groups A,B,C and D. As usual, when for example, data for Group D is not present in the selected date range - it disappears and only A, B and C are displayed. But the business wants all 4 groups to stay permanently on the screen and only data to change based on the date range selection.
Is there a way to achieve this?
Thank you,
nhuda
Solved! Go to Solution.
Thanks Greg,
I ended up creating another table with Group column and related it with the Group in my original, then used the column in the new table to be in the Report table and that solved it. But your's one is even simpler.
Great tip, thank you!
nhuda
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |