Forum Discussion
Conditional Format all columns up to a certain column based on values
Anonymous , Try using below method
Create a New Column for Validation
Open your Power BI Desktop and load your data.
Go to the "Data" view.
Create a new column by clicking on "New Column" in the Modeling tab.
Use the following DAX formula to create a validation column:
Validation =
VAR CurrentTeam = 'Table'[Team]
VAR CurrentPhase = 'Table'[Phase]
VAR CurrentSubphase = 'Table'[Subphase]
VAR CurrentValue = 'Table'[Value]
VAR PreviousPhases =
FILTER(
'Table',
'Table'[Team] = CurrentTeam &&
Apply Conditional Formatting
Go to the "Report" view.
Select the table visual where you want to apply the conditional formatting.
Click on the down arrow next to the column you want to format (e.g., Value).
Select "Conditional formatting" > "Background color".
In the "Background color" window, select "Field value" under "Format by".
Choose the Validation column created
Set the color for "Invalid" to red and "Valid" to no color or a different color as needed.
Is there more to the FILTER? What is the condition?