Forum Discussion

fionamann_'s avatar
fionamann_
Frequent Visitor
2 years ago
Solved

One slicer interacting with multiple numeric columns

Hi,   I have a table in Power BI which has seperate columns with the number of transactions that happened in each month.   Account Month 1 Month 2 Month 3 Month 4 A 38 28 12 39 B...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hello fionamann_ ,

     

    For your question, I have created the following table.

     

     

    Then you can set the field parameters

     

    Then write the following measures and apply it to your table

    Measure = SWITCH(TRUE(),
    ISFILTERED('Parameter'[Parameter Fields])=FALSE(),1,
    SELECTEDVALUE('Parameter'[Parameter Order])= 0 && MAX('Table'[Month1])>10,1,
    SELECTEDVALUE('Parameter'[Parameter Order])= 1 && MAX('Table'[Month2])>10,1,
    SELECTEDVALUE('Parameter'[Parameter Order])= 2 && MAX('Table'[Month3])>10,1,
    SELECTEDVALUE('Parameter'[Parameter Order])= 3 && MAX('Table'[Month4])>10,1,
    0)
    

     

     

    This is the result

     

     

     

    Best Regards,

    Jayleny

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