Need help to create filter on numerical data from column header

[Anonymous]

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

[amitchandak · Accepted solution]

@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-slic...
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://www.youtube.com/watch?v=vlnx7QUVYME

[v-zhenbw-msft · Accepted solution]

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.

[amitchandak · Accepted solution]

@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-slic...
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://www.youtube.com/watch?v=vlnx7QUVYME