Forum Discussion

sunilbeckham's avatar
sunilbeckham
Icon for Helper I rankHelper I
3 years ago
Solved

Hide values in field parameters

Hello. I have multiple columns in my table that look something like this: Student ID Assessment Awareness of Self and environment Assessment Cognitive Skills Assessment Language and commu...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi sunilbeckham ,

     

    Please create a new measure like:

    Measure = 
    SWITCH(
        SELECTEDVALUE('Assessment'[Assessment Order]),
        0, IF(SELECTEDVALUE('Table'[Assessment Awareness of Self and environment]) IN {"1","2","3"},1),
        1, IF(SELECTEDVALUE('Table'[Assessment Cognitive Skills]) IN {"1","2","3"},1),
        2, IF(SELECTEDVALUE('Table'[Assessment Language and communication]) IN {"1","2","3"},1),
        3, IF(SELECTEDVALUE('Table'[Assessment Physical - Fine Motor]) IN {"1","2","3"},1),
        4, IF(SELECTEDVALUE('Table'[Assessment Physical - Gross Motor]) IN {"1","2","3"},1),
        5, IF(SELECTEDVALUE('Table'[Assessment Social skills..]) IN {"1","2","3"},1)
    )

    and then use it as visual's filter:

     

    Best Regards,
    Gao

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum