Forum Discussion

AnonEMoose's avatar
AnonEMoose
Frequent Visitor
2 years ago
Solved

Possibility of dynamically hiding values in multiple columns based on a slicer?

I'm not even sure if Power BI has the capability to this, but what I'm trying to do is essentialy "hide" values dynamically based on a slicer or some other way to specify values (less than 2, between...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    2 years ago

    Hello AnonEMoose ,

     

    you create a numeric parameter that you would use to specify the number , then you apply the following dax

    C1 value = IF(SELECTEDVALUE('Table'[C1]) < Parameter[Parameter Value],BLANK(),SELECTEDVALUE('Table'[C1]))




    if you want to have values between, then you create another numeric parameter and adjust the dax to greater than parameter one and less than parameter 2.

     

    attached is the pbix that i used to demonstrate the above.

     

     

Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
2 years ago

Hello AnonEMoose ,

 

you create a numeric parameter that you would use to specify the number , then you apply the following dax

C1 value = IF(SELECTEDVALUE('Table'[C1]) < Parameter[Parameter Value],BLANK(),SELECTEDVALUE('Table'[C1]))




if you want to have values between, then you create another numeric parameter and adjust the dax to greater than parameter one and less than parameter 2.

 

attached is the pbix that i used to demonstrate the above.

 

 

AnonEMoose's avatar
AnonEMoose
Frequent Visitor
2 years ago

This was 90% of what I needed, and I was able to figure out the other 10%. Thank you for your help!