The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi There,
I am having asn issue while creating conditional formatting.
I have one column which is Service Level (%) and having values in % along with that i have criteria based on LOB'S present in my data.
I am struggling to apply conditional formatting . Can anyone help me in acheving below requirement :
So I need Conditional formatting in Serivce Level columns based on Conditions given .
Request to please help me in achieving this .
Regards,
Ash
@amitchandak @Ashish_Mathur
Solved! Go to Solution.
Hi @Anonymous
Create a measure in your table and use that for formatting:
Then assign this to your field formatting:
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
(lob = "D" || si in {"d(I)",d(ii)}) && ser > 60
Need the brackets so they happen at the same time.
Assuming its Lob = D OR Si = "d(i)" if it is AND use &&
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Hi @Anonymous
Create a measure in your table and use that for formatting:
Then assign this to your field formatting:
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Hi @SamWiseOwl
I also need to add two more conditions which is in different columns .
Can you tell what should i modify in this?
Thanks,
Ashish
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Thank you @SamWiseOwl
Just forget to add D aslo has SI level d(i) and d(II) . So can i add like this ;
(lob = "D" || si in {"d(I)",d(ii)}) && ser > 60
Need the brackets so they happen at the same time.
Assuming its Lob = D OR Si = "d(i)" if it is AND use &&
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
Hi @Anonymous
These might be helpful.
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
https://www.youtube.com/watch?v=m0h3Ghl6mgY
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!
Hi @Anonymous ,
You could do this by creating a new calculated column that captures your criteria ( using SWITCH and IF statements) and returns the corresponding hex color code. Then you can use this calculated column to drive the conditional formatting of the service level column.
I hope this helps!
Proud to be a Super User! | |
User | Count |
---|---|
82 | |
81 | |
37 | |
34 | |
31 |
User | Count |
---|---|
94 | |
80 | |
60 | |
50 | |
49 |