Forum Discussion
Filter with Criteria
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
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.
3 Replies
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
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.
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.
