Forum Discussion
Need help to do filter in slicer data
Hi,
I want to show my data based on my filter values in slicer visualization. I have platform column in my table. I want to show this platform data in a slicer visualizations and it shows only Monospace 500 details.
Platform slicer contains should following data instead of all the above data.
Monospace 50012.1
Monospace 500 13.2
Monospace 500 12.3
There is no visualization filter available for Slicer. My slicer shows all the data of Platform coulmn from Product table. I am trying to create new table for platform cloumn and filtering out only monospace products using DAX table but I dont know which function for applying "contains" filtering function like as page level filter for string search. I want to grouping monospace
Could you please anyone suggest that how can i apply filter in slicer?
Thanks in advance.
Regards
Sridevi
Hi sridevi,
You can use "SELECTCOLUMNS function" to choose the columns which you need:
I added to new columns to base table:
Use "SELECTCOLUMNS" to filter other columns:
Table = SELECTCOLUMNS( FILTER(Table1,ISERROR(SEARCH("Monospace 500",Table1[platform]))=FALSE()),"Platform",[Platform])
In additon, allexcept function also worked.
Table = CALCULATETABLE(ALLEXCEPT(Table1,Table1[Column],Table1[Column 2]), FILTER(Table1,ISERROR(SEARCH("Monospace 500",Table1[platform]))=FALSE()))
Regards,
Xiaoxin Sheng
7 Replies
Hi,
I don't know if you have tried this, but adding "Platform" to the page or report level filter sections, then filtering out all but Monospace should filter the slicer.
Check out this post about filtering a Slicer visual:
http://radacad.com/filtering-slicer-resolved-in-power-bi
Hi asocorro,
Thanks a lot for your suggestion. I have implemented as per the below link information. Yes it was working fine but problem here is its creating new table with all the columns and filtering based on platform which I have specified in search. Its simply creating dupliate of table with filered data. My table has morethan 1000 columns so its recreated again same data set. It may be occupied lot of storage memory. Is that any other way to do filtering?
Thanks in advance.
Regards
Sridevi
Hi sridevi,
You can use below methods to filter the data in slicer:
1. Page level filter(bullius’s point of view):
2. Query editor filter rows:
3.Dax search function.
Table = FILTER(Table1,ISERROR(SEARCH("Monospace 500",Table1[platform]))=FALSE())
Regards,
Xiaoxin ShengThanks a lot for all of your responses.
Yes I knew about page and report level filters and I used in my usecase aswell. But here I dont want to apply this filter in page and report level. I have arleady PLATFORM data column in slicer visualization format and I need to filter only monospace 500 related products for one of my usecase. I have many slicers in my page so I apply page level it should be affected my other slicers and charts. So Its not appropriate for my requirement. I need to apply filter only my platform slicer.
If I use page and report level filters and query editor filters then it will be affected my whole report and report might be wrong.
Anonymous: Thank you for your suggestion. I have created new table with the help of DAX query but problem is here, it has all other columns as well. I want to have only platform data with use of DAX syntax for filtering monospace 500. Is that any other way to generate only platform column in new table or shall I have filter it existing table which has platform field for this particular silcer.
Thanks a lot for all of your suggestions.
Regards
Sridevi
Hi sridevi,
You can use "SELECTCOLUMNS function" to choose the columns which you need:
I added to new columns to base table:
Use "SELECTCOLUMNS" to filter other columns:
Table = SELECTCOLUMNS( FILTER(Table1,ISERROR(SEARCH("Monospace 500",Table1[platform]))=FALSE()),"Platform",[Platform])
In additon, allexcept function also worked.
Table = CALCULATETABLE(ALLEXCEPT(Table1,Table1[Column],Table1[Column 2]), FILTER(Table1,ISERROR(SEARCH("Monospace 500",Table1[platform]))=FALSE()))
Regards,
Xiaoxin Sheng
