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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi sunilbeckham ,

 

Normally, this needs to be sorted with the help of auxiliary columns, but in this case it doesn't apply.

 

You may consider using Unpivot for these columns in the PowerQuery editor.

Because the values on this axis originate from the same field, consider using a visual filter. Reference sample files

 

Best Regards,
Gao
Community Support Team

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

Thank you so much for your help. I really appreciate it.