topic Re: Regarding power bi button hide/show based on condition in Developer

Regarding power bi button hide/show based on condition

Anonymous — Wed, 10 Jul 2024 09:10:50 GMT

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.

Re: Regarding power bi button hide/show based on condition

lbendlin — Thu, 11 Jul 2024 00:10:28 GMT

if a column value contains "SP"

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

Re: Regarding power bi button hide/show based on condition

Anonymous — Mon, 15 Jul 2024 09:32:00 GMT

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.