Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I am thinking on how to get my cells formatted based on calculations but can't find a solution currently. Don't know whether to use the IF or SWITCH function for it as SWITCH only seem to apply on created measures.
The table I have, assume it is called (Table[])
Condittional formatting I want should apply to Delivery Order or Shipment No and colours I want to use are Orange, Green, Red or no colour (Black):
If (Table.[IOD Date]) <= (Table.[Arrival Date]) And (Table.[status]) = "IOD" ; Green
If (Table.[Arrival Date]) = Today and (Table.[IOD Date]) = Blank ; Orange
If (Table.[Arrival Date]) < Today And (Table.[Status]) = "Ship" ; Red
If (Table.[IOD Date]) > (Table.[Arrival Date]) And (Table.[Status]) = "IOD" ; Red
Else no colour (Black).
Who could help me out? @amitchandak maybe?
Thanks in advance!
Kind Regards,
Sofiën
Solved! Go to Solution.
Hi @v-luwang-msft ,
Solved it by creating a column like below and doing conditionnal formatting based on numbers 1 till 5.
Hi @v-luwang-msft ,
Solved it by creating a column like below and doing conditionnal formatting based on numbers 1 till 5.
There is an easier way to do Conditional Formatting. You can achieve this without a measure as well. Below are the steps –
Click on the Down Arrow in front of the Column Name under Values Tab and Select Conditional Formatting > Background Color
A new Background Color window will pop up – fill all the details, select the colors you want and click on OK.
That’s it, the colors will show up on your chart –
Let me know this works for you.
Hi @AnamPatel
I know you can do it like this as well, but this won't work for me as my colours are based on calculations which I mentioned above. In the screen you shared you need to select Field Value after selected Conditionnal Formatting and then within Field Value enter the measure with SWITCH function probably.
Kind Regards,
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
107 | |
101 | |
99 | |
38 | |
37 |
User | Count |
---|---|
157 | |
121 | |
73 | |
73 | |
63 |