Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Friends,
I am new to PBI and working on some reports where I have below table data loaded into PBI that I am showing in a Table visual.
ID | Type | SP |
1002 | User Story | 3 |
1003 | Task | |
1004 | Task | |
1005 | Task | |
1006 | User Story | 2 |
1007 | Task | |
1008 | Task | |
1009 | Bug | 1 |
1010 | User Story | |
1011 | Task | |
1012 | User Story | 1 |
1013 | User Story | |
1014 | User Story | 2 |
1015 | Task | |
1016 | Bug |
I want the SP column in the table visual to have specific background color as per the below conditions:
If the Type = User Story OR BUG and SP is NOT Blank (having any positive value) then the SP cell background color should be GREEN
If the Type = User Story OR BUG and SP IS Blank then the SP cell background color should be RED
if the Type <> User Story OR BUG then the SP cell background color should be a GRAY color.
Expected visual:
Please suggest.
Thanks,
Prabhat
Solved! Go to Solution.
@prabhatnath Creeate measure as per below:
Measure 2 = var _type = MIN('Table (2)'[Type])
var _sp = MIN('Table (2)'[SP])
return
IF((_type = "User Story" || _type = "Bug") && _sp >0 , 1,
IF((_type = "User Story" || _type = "Bug") && _sp = BLANK() , 2,
IF((_type <> "User Story" || _type <> "Bug") ,3,0)))
Please accept as solution if its worked.
@prabhatnath Creeate measure as per below:
Measure 2 = var _type = MIN('Table (2)'[Type])
var _sp = MIN('Table (2)'[SP])
return
IF((_type = "User Story" || _type = "Bug") && _sp >0 , 1,
IF((_type = "User Story" || _type = "Bug") && _sp = BLANK() , 2,
IF((_type <> "User Story" || _type <> "Bug") ,3,0)))
Please accept as solution if its worked.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
95 | |
80 | |
77 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |