Need help

[Anonymous]

Hi Guys,

I have a query on filters and table visual...

I got one filter let say Date filter and two tables...Table1 is working on the above Date filter, so let's say if I apply any date on filter, it shows me customer IDs in Table1 based on above selected filter...now I want to show the historical trends for the customers available in Table1 to Table2...se let say I applied filter on today's date, I got 10 Customer IDs who made purchase today and it will show in my Table1 visual, however I want Table2 to display only those 10 customer IDs which are available in Table1 but with no date filter applied on it...So it should show me these 10 customer IDs with all dates available to see their historical purchase in Table2 visual...

Please assist the solution...

Regards,

Atif

[Anonymous]

Hi,

Thanks for the reply, I applied same steps however its not working for me...the only difference is, you created and connected different tables like date, customerID and actual data, however I have everything in one single table, splitted by columns...like date, customerID and Order Amount...

Please suggest how to achieve it from one single table...

Regards,

Syed

[v-jingzhang]

Hi @Anonymous 

I cannot think of a solution when data is from one single table. Columns in a table have relationships between each other, so one column is always able to filter another. That's why I duplicate the Orders table and make the duplicated one disconnected with the Date table. In this way, the Date table cannot filter the "Orders 2" table. But my solution has a downside that it will enlarge the data model size. If the Orders table is huge, duplicating Orders table will nearly double the data size. This may make the refresh slow. 

Best Regards,
Jing

[v-jingzhang]

Hi @Anonymous 

I create a sample file with some data, hope it would be helpful. You can download the file at bottom. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.