Forum Discussion
wbart
Helper I
Helper Ifilter by groups defined in tables
Hello, I try to simply filter my data by several predifined groups. The data is stored in a table and every group is stored in a seperate table. I maybe missed it, but is there a simple way to selec...
Hi wbart
You need to define which item belongs to which group first in the table. Then you can create a relationship between the data table and group table on item columns. In this way you can use the group column in a slicer or filter or something else to filter the data table. The filter influence is passed by the relationship between tables. This is the easiest way.
Reference: Model relationships in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
amitchandak
Super User
Super Userwbart ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.