Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to create a custom slicer?

Hello   I have repeatedly asked for some clarity on how to create a custom slicer but I get answers that are not self-explanatory.  Please if you don't want to describe ALL the steps to achieve th...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    You can filter the value in the filter panel with measure =1, like below:

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , Assumption is that col1 is in independent table

measure =
var _max = maxx(allselected(Table),Table[Col1 ])
return
calculate(countrows(Table1), filter(Table1,containsstring(Table1[Column1],_max)))