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.

     

MFelix's avatar
MFelix
Super User
1 year ago

Hi testingname ,

 

I refer to the Calculation you have already performed, or are you just adding the columns directly without any measure?

testingname's avatar
testingname
Frequent Visitor
1 year ago

"Monthly Report" is currently being kept to the most recent 6 months from the max date by a column generate in SQL.  Using that will not work, because the column delivers a set value based off of the MAX "Monthly Report" date.

I'm looking to create something similar, but dynamic...based off of a slicer's selected value.

 

 

  • MFelix's avatar
    MFelix
    Super User
    1 year ago

    Hi testingname

     

    Apologies for the question but maybe I'm not understanding how you have the calculations setup.

     

    Is it possible to send a mockup of the pbi file?