Forum Discussion
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 if anyone faced similiar scenario or having a solution for this.
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.
2 Replies
if a column value contains "SP"Please be more specific. What do you mean by "column value"? Are you talking about scalars or tables?
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.
