05-17-2017 11:57 AM - edited 05-17-2017 12:11 PM
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|
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?
05-19-2017 01:07 AM
Based on my test in Power BI desktop 2.46.4732.721 64-bit (May 2017), if there is only one row in the table visual, as long as the column has set aggregation or put a measure with aggregate function, Conditional Formatting is available.
In your scenario, please use the same desktop version as ours. If issue persists, please share the .pbix file with us if possible.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
05-19-2017 07:12 AM
I do have the May 2017 update, and the problem isn't that I can't set conditional formatting, it's that the conditional formatting doesn't appear once set.
The data is confidential, but let me see if I can replicate the problem with some entered data and share that.
05-19-2017 09:45 AM
The first page is the example of the table in which the conditional formatting doesn't show up. The second page is the example of the workaround I found, which visually isn't really what I want.
It's a bit simpler than what I'm actually doing, but the basic structure of the databases and the visual is the same.
In reality, there are several tables in the report like the one in the example, with a summary at the top, all with the same format so they read rowwise.
07-12-2017 09:44 AM - edited 07-12-2017 09:52 AM
07-12-2017 09:53 AM
@PataPaul Unfortunately no. I've been using the matrix workaround I mentioned in my first post, hoping Microsoft will get around to solving the bug.
I'm using the latest version of PowerBI desktop and still having the same error