Forum Discussion
Conditionals formatting based on a column in the same visualization table
- 2 years ago
PFA , PBIX with table
mhablas426 , You can create a simple DAX for this
Column2Color =
IF(
SELECTEDVALUE('YourTable'[Column2]) > SELECTEDVALUE('YourTable'[Column3]),
"Red",
"Green"
)
Select the Table Visual: Click on the table visual where you want to apply the conditional formatting.
Open Conditional Formatting Options:
Go to the Format pane.
Expand the Conditional formatting section.
Click on the fx button next to the Font color option for the column you want to format (Column 2 in this case).
Set Up Conditional Formatting:
In the Conditional formatting window, select Field value under the Format by dropdown.
In the Based on field dropdown, select the measure you created (Column2Color).
Apply the Formatting: Click OK to apply the conditional formatting.