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 ,

 

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

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

    Hi Anonymous 
    This was brilliant. Thank you so much for your help, I really appreciate it ğŸ˜€

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

    Anonymous I have a quick follow up question if you don't mind.
    I'm trying to sort the X axis now by column descending so that it's always in the order of 3,2,1. But it doesn't save the order of the axis when I select a different column from the field parameter slicer.
    For example, I select 'Cognitive Skills' from the Assessment Group slicer, and I sort the axis on the visual by 'Assessment Cognitive Skills' column descending. It gives me the desired output 3,2,1. But when I select another Assessment from the slicer, It changes the order again and goes back to sorting it by Y axis.
    See screenshot below:

     


    Thanks in advance!

     

     

    • 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.