Forum Discussion
Add filter to report to exclude fields from a visual?
Hi jensvanbellen ,
As I can see from your screenshot, you created a measure for each field in sclier and put them in values, the filter was fixed in measure , so you can't use slicer directly to filter legned.
I suggest you create a summary table union all the measure into one table(without your sample data ，I cannot provide a detailed formula). You can refer to my post in https://community.powerbi.com/t5/Desktop/Multi-Line-Diagram-to-compare-plants-with-categories/td-p/1446233
If you need further help, please show me your sample data by onedrive for business.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Community SupportHi jensvanbellen ,
As I can see from your screenshot, you created a measure for each field in sclier and put them in values, the filter was fixed in measure , so you can't use slicer directly to filter legned.
I suggest you create a summary table union all the measure into one table(without your sample data ，I cannot provide a detailed formula). You can refer to my post in https://community.powerbi.com/t5/Desktop/Multi-Line-Diagram-to-compare-plants-with-categories/td-p/1446233
If you need further help, please show me your sample data by onedrive for business.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai