1. Load your data:
Open Power BI Desktop and load your dataset.
2. Open Power Query Editor:
Go to the "Home" tab and click on "Transform Data" to open the Power Query Editor.
3. Add a Conditional Column:
In the Power Query Editor, go to the "Add Column" tab.
Click on "Conditional Column".
4. Define the conditions:
In the "Add Conditional Column" dialog box, provide a name for your new column.
Set the conditions for your column. For example, if you want to apply different formatting based on sales values, you can set conditions like:
If [Sales] is greater than 1000, then "High"
If [Sales] is between 500 and 1000, then "Medium"
If [Sales] is less than 500, then "Low"
5. Add more conditions if needed:
Click on "Add Clause" to add more conditions as required.
6. Apply the changes:
Click "OK" to create the new conditional column.
7. Close and Apply:
Once you're satisfied with the changes, click "Close & Apply" to return to the main Power BI window with the updated data.