Conditional formatting for non-summarized item

Question

Data source is a live-connected SSAS Tabular Model.

I have a numeric field in a table, and I'd like to conditionally format the values for that field in that table. I have two issues:

1. If I have the value set to not summarize, I can't access a conditional formatting menu.

2. The field is a GPA field. I only want to highlight values <=1.5. I can't figure out how to do anything other than change colors along the entire spectrum of values for the field.

th3h0bb5 · Answer

Can you attach a picture of the visualization you're wanting?

If you're doing something like a table, just break it down to the highest level of detail. That way, each GPA value will have it's own line. You don't need to click 'don't summarize' that point and can apply conditional formatting. In the example I pasted below, each Month has it's own row in the data, so I can conditionally format the purchase values.

jayeckles · Answer

Here's a screenshot. &nbsp;trmgpa is the field in question. &nbsp;As you can see, if it's set to "Don't summarize", there is no "Conditional Formatting" option. &nbsp;If I choose any summarization, say Average for example, then the "Conditional Formatting" option becomes available.&nbsp;&nbsp;

th3h0bb5 · Answer

Given this visual, I don't see why you would need to click 'Don't Summarize'. Set&nbsp;the&nbsp;[trmgpa] calculation&nbsp;to average or sum and then apply the conditional formatting. Is there a reason that didn't work for you?

jayeckles · Answer

I have no desire to summarize on the field. &nbsp;For one, I have records that have no value (null) for that field. &nbsp;For another, none of the summarizations are particularly useful in this context. &nbsp;I just want the value to be red if &lt; 1.5. &nbsp;

th3h0bb5 · Answer

Gotcha. Provided that this is the lowest level of detail though, your aggregate&nbsp;will be identical to your value.&nbsp;For example, take the top row of your table:&nbsp;If this represents a single row in your data source (let's say this is Bill's row), then&nbsp;Bill's GPA&nbsp;is 3.16. 3.16 is also the average of Bill's GPA&nbsp;and the sum of his GPA (since there is no other data taken into the calculation except for Bill's on this row).&nbsp;Which takes me back to my initial remark; if you are at the lowest level of detail (Bill gets his own row and is not grouped in with anyone else), then you don't need to click 'not summarized' and can use conditional formatting.

Forum Discussion

Conditional formatting for non-summarized item

7 Replies

Related content

Conditional Formatting

Conditional Formatting using DAX

Conditional Formatting

Matrix Row Conditional Formatting

Condition formatting