Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Regarding power bi button hide/show based on condition

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 i...
General Comment
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.