Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I have a column called Status which shows the status for each row, filled with either a G, C, IP etc: see below all the RAG's I have.
The conditional formatting on the report builder only works for G and R. I have also tried creating a new column with switch and IF functions to replace the alphabetical values with numerical which resulted in only G and R being converted to numbers. I also tried to create a conditional column in power query to achieve the switch to numbers, but get the same thing; only G and R get populated and I get a "Null" for all the others.
G (Green)
IP (In-Progress)
OH (On-Hold)
R (Red)
NS (Not-Started)
C (Complete)
Any advise on how to fix this?
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Here you go
Summary Status | Status |
SUMMARY 1 | G |
SUMMARY 2 | IP |
SUMMARY 3 | IP |
SUMMARY 4 | C |
SUMMARY 5 | R |
SUMMARY 6 | A |
SUMMARY 7 | G |
SUMMARY 8 | IP |
SUMMARY 9 | IP |
SUMMARY 10 | C |
SUMMARY 11 | OH |
SUMMARY 12 | G |
SUMMARY 13 | IP |
SUMMARY 14 | IP |
SUMMARY 15 | G |
SUMMARY 16 | G |
SUMMARY 17 | NS |
SUMMARY 18 | NS |
SUMMARY 19 | C |
SUMMARY 20 | OH |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
90 | |
72 | |
69 |
User | Count |
---|---|
232 | |
128 | |
117 | |
82 | |
82 |