Forum Discussion

testingname's avatar
testingname
Frequent Visitor
1 year ago
Solved

Power BI/DAX: dynamically filter table values with slicer

I have a Power BI table visual with a column "Monthly Report" containing text values such as "2024 08 August" "2024 09 September", etc... There is an associated column "Monthly Rank" with numerical v...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, testingname 

     

    You can try the following methods. Create a new slicer table.

    Slicer = VALUES('Table'[Monthly Report])
    Measure =
 Var _rank= CALCULATE(MAX('Table'[Monthly Rank]),FILTER(ALL('Table'),[Monthly Report]=SELECTEDVALUE(Slicer[Monthly Report])))
RETURN
IF(SELECTEDVALUE('Table'[Monthly Rank])<=_rank&&SELECTEDVALUE('Table'[Monthly Rank])>=_rank-5,1,0)

    Is this the result you expected?

     

    Best Regards,

    Community Support Team _Charlotte

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

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, testingname 

 

You can try the following methods. Create a new slicer table.

Slicer = VALUES('Table'[Monthly Report])
Measure =
 Var _rank= CALCULATE(MAX('Table'[Monthly Rank]),FILTER(ALL('Table'),[Monthly Report]=SELECTEDVALUE(Slicer[Monthly Report])))
RETURN
IF(SELECTEDVALUE('Table'[Monthly Rank])<=_rank&&SELECTEDVALUE('Table'[Monthly Rank])>=_rank-5,1,0)

Is this the result you expected?

 

Best Regards,

Community Support Team _Charlotte

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