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
Hi v-deddai1-msft, thanks for your reply. In the meantime I build another solution as well that brings me close to what I initially wanted to accomplish. I made a new table with the Power Query Editor with the listed metrics I wanted the users to select and a key, something like this:
Metric Key Website sessions 1 Facebook post impressions 2 etc. etc.
Then I added a slicer to the page with the graph where the user can select the Metric from fore-mentioned table. Next I created a new measure in which I used the SWITCH() function to switch out the variable depending on which Metric (and thus Key) the user chose in the slicer. I then use this new measure for the graph I have on the page. The only thing with this now is that so far I can only manage to display one metric at a time in the graph...Thanks for your solution, I will try that as well! 😃
The result looks like this.
