Want slicer filter for top 10 & top 100 order count.

[navneet0512]

I want to sclicer filter from where I can select top 5 top 10 top 100 on order count .

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[v-tangjie-msft]

Hi @navneet0512 ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data. 

(2) We can create a table.

Slicer = DATATABLE ( 
    "Slicer", STRING, "Index",INTEGER,
    {
        { "top 5",1},
        { "top 10",2 },
        { "top 100",3 }
    }
) 

(3) We can create a measure.

Flag = SWITCH(TRUE(),
ISFILTERED('Slicer'[Slicer])=FALSE(),1,
SELECTEDVALUE('Slicer'[Slicer])="top 5" && MAX('Table'[rank])<=5,1,
SELECTEDVALUE('Slicer'[Slicer])="top 10" && MAX('Table'[rank])<=10,1,
SELECTEDVALUE('Slicer'[Slicer])="top 100" && MAX('Table'[rank])<=100,1,0)

(4) Place [Flag=1] on the visual object screening and then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[navneet0512]

Rank is measure created on count of order number .

[v-tangjie-msft · Accepted solution]

Hi @navneet0512 ,

Update the [Flag] measure.

Flag = SWITCH(TRUE(),
ISFILTERED('Slicer'[Slicer])=FALSE(),1,
SELECTEDVALUE('Slicer'[Slicer])="top 5" && [rank measure]<=5,1,
SELECTEDVALUE('Slicer'[Slicer])="top 10" && [rank measure]<=10,1,
SELECTEDVALUE('Slicer'[Slicer])="top 100" && [rank measure]<=100,1,0)

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.