Not sure if this is a glitch, or if anyone else has had this problem. Haven't found a solution posted so far:
I'm building a model for perfomance reports, in which indicators are grouped into 1-row tables. For each indicator, there is the amount acheived, the goal, what percent of the goal was achieved, and the resulting grade. The dashboard has several tables, each of which looks something like this:
| Training groups opened | | | | | | | | | |
| Methodology 1 | Goal 1 | Attained 1 | Result 1 | Metodology 2 | Goal 2 | Attained 2 | Result | Methodology 3 | Goal 3 | Attained 3 | Result 3 |
| 8 | 8 | 100% | Satisfactory | 7 | 8 | 88% | Deficient | 16 | 12 | 133% | Exceeded expectations |
Let's say the grade is broken down into 3 categories: 0-99% of goal, 100-119% of goal, 120%+ of goal, and that the goals are fixed. The "Methodology", "Attained" and "Result" cells are all computed measures, and the "Goal" cell is inputted data.
Ideally, I'd want the "Result" cell to have a 3-color conditional formatting scale like Excel, but I know that in Power BI you can't put conditional formatting on a text value, and 3-color scales are not allowed. However, you can set a min and max value, so my workaround is to put this condition on the "Methodology" cell.
The issue is that the conditional formatting doesn't appear unless I add a second row, which for the purposes of this report isn't what I want to do. A workaround is to change the visual to a matrix, add a calculated column such as "Training groups opened = BLANK()", and set this measure as the row field. However, this is cumbersome and isn't as appealing visually.
My question is: if I am doing something wrong, what I need to change; or is this just a bug in the program?
