Forum Discussion
Hide values in field parameters
- Anonymous3 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 TeamIf 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
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
Hi Anonymous
This was brilliant. Thank you so much for your help, I really appreciate it 😀