Forum Discussion
Need help to create filter on numerical data from column header
I can create text filters with the slicer to show populater information such as , Region, Country, Site, Division etc.
I have 8 columns of numerical data for an inventory report.
I need to create a filter to select the column header text which is Gross and one for Net but cannot get this to work on slicer or other tools.
Is there a simple way to do this.
See screen shot below
@johnnytarr, not very clear. Are you looking for the cutter
measure the cutter
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://www.youtube.com/watch?v=vlnx7QUVYMEHi Anonymous ,
We can create a calculate column and use it to be a slicer to meet your requirement.
1. Create a column to group Gross and Net.
Gross or Net = SWITCH( TRUE(), CONTAINSSTRING('Table'[Group],"Gross"),"Gross", CONTAINSSTRING('Table'[Group],"Net"),"Net", "Others")2. Then we can create a slicer based on Gross or Net column. It can control the lines.
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
2 Replies
- amitchandak
Super User
@johnnytarr, not very clear. Are you looking for the cutter
measure the cutter
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://www.youtube.com/watch?v=vlnx7QUVYME 
v-zhenbw-msftCommunity Support
Hi Anonymous ,
We can create a calculate column and use it to be a slicer to meet your requirement.
1. Create a column to group Gross and Net.
Gross or Net = SWITCH( TRUE(), CONTAINSSTRING('Table'[Group],"Gross"),"Gross", CONTAINSSTRING('Table'[Group],"Net"),"Net", "Others")2. Then we can create a slicer based on Gross or Net column. It can control the lines.
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.