Filter with Criteria

[Syndicate_Admin]

Dear good morning I hope you can help me.

I have to report sales by criteria i.e. mth is period 1, qm are periods 1, 2 and 3, as shown in the Criterion table, the periods are associated with the date of sale.

What I need is to select, the criteria and tell me what was sold in those 3 months. Now everything comes out the same.

I attach the pbix file and the xls used.

https://drive.google.com/drive/folders/1kbSfZX1uJkw-0MdgxmH_WjnXRtNYp3Mr?usp=sharing

Thank you very much in advance for your answers

[Anonymous · Accepted solution]

Hi @jminanoc ,

Try to change the direction of the relationship to both, so that the filter can filter correctly.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Syndicate_Admin , No access, applied for it. But is there a table we have Values for QM - 1,2,3 and QM-1 = 4,5,6

Then we should be able to display

but seems like that filter and table with values are not interacting

[Syndicate_Admin]

Hello, thanks for the review, actually if it is all, in the Criterion table are the periods for what you indicate and in the period table is the date associated with the period, and in the data table is shown by dates, the relationships are fine.