How to prevent dynamic disappearance of Rows based on date range selection

[nhuda]

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

[nhuda]

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

[Greg_Deckler · Accepted solution]

@nhuda