Regarding power bi button hide/show based on condition

[Anonymous]

Hi All,

We are having a scenario where we need to hide/show based on a condition. For example, if a column value contains "SP" button needs to be visible and hide if its not. Please let me know if anyone faced similiar scenario or having a solution for this.

[Anonymous · Accepted solution]

Thanks for the reply from @lbendlin , please allow me to provide another insight: 
Hi  @Anonymous ,

You might consider making the backgrounds of visual objects, fonts, and font backgrounds transparent using the Conditional Formatting metric of the Field Value option.

Create measure：

Color =
IF(
    "SP" in SELECTCOLUMNS('Table',"test",[Column1]),"#FFFFFF00", "000000")

Button – Style:

Open Text :

Enter the Button name

Font color – fx

Closing the border

When there is "SP" in [Column1], the button will be hidden:

When there is no "SP" in [Column1], it will be the text in the button:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

 if a column value contains "SP" 

Please be more specific.  What do you mean by "column value"?  Are you talking about scalars or tables?