Conditional Formatting not applying as expected when using Percentages

[IanDavies]

I have a matrix, it has Business Names as Row headers and a Status as Column Headings

I cound the status per business like this and you can see that some have the same value in Full as in  Total (this is what we want)

If I convert these to % you can see them displayed as you wuold expect at 100.00%

but if I add Conditional formatting (Icons) based on the % it doesnt apply as one might expect

I want those with 100.00% to be green and thoswe with less to be red - what on earth is going on here?

all help appreciated.

[HotChilli]

Well, not really. I want to know what the actual problem is (is it conditional formatting? Please confirm this)

--

Let's take the sample data you have shown in that last post. What's the desired outcome from that? (please show me)

[IanDavies]

If we take this matrix:

instead of the actual values I'd like to see percetanges... something like this:

Business	Full	Selective	Idle	Total
Bu1	7%	2%		58
Bu2	100%			11
Bu3	100%			11
Bu4	41%	1%	58%	71

As a business we have move don and are just using the numbers, but it would be nice to understand the solution if you still feel like having a look at this.

[HotChilli]

"I'd also like to understand the phrase "the rule boundaries as a percent of the overall range of values" as I don't know what you mean by that and therefore don't really understand what was wrong." - that's not my phrase. That's in the linked article which has examples to explain this.

--

"what I need to show, ideally, is the count "full" as a % of the row total...  Ideally it would be in an additional column so we have the count and the % but thats not necessary." - I thought that you managed to do that first part (in the original post) but it was the conditional formatting that you were having trouble with.

-

My initial response assumed that the measure you are using in the matrix had been formatted as percentage (or the datatype of the base field of the measure was a percentage) and, when using percent in the rules of conditional formatting this was giving unplanned results. Is this a true reflection of the problem or is it something else?

[IanDavies]

The number in each column is an integer, it is not formatted as a percentage. The matrix is a count of values with subtotals per business and per state and does this count itself, The data is a single column in a table that indcates the state of that asset one each row.

the raw data would look like this in its simplest form (obviusly there are other columns as well)

Name	Enforcment State
asset 1	full
asset 2	selective
asset 3	full
asset 4	Idle
asset 3	full
asset 4	Idle

Is this what you were asking

[HotChilli]

You have a reasonable point about the solution being accepted. It was done by one of the community support team and we don't have any control over that. I'm not too harsh on this type of behaviour because they have a job to do and we superusers are just dabblers.

Ok, to the problem itself - the link shows how to use conditional formatting when your values are in percent datatype. I'm open to you telling me it doesn't work for you. Tell me what happened when you implemented the suggested solution and why it doesn't fit your use case and i will attempt to help.

[IanDavies]

Oh, that's interesting, why would community suport folk do that... anyway, as you say its really outside the scope of this discussion. I was a bit angry when it was marked such as it felt my experience was being ignored, but thats not on you and I thank you for your further reposnse.

so, looking at this table:

what I need to show, ideally, is the count "full" as a % of the row total...  Ideally it would be in an additional column so we have the count and the % but thats not necessary.

I'd also lilke to understand the phrase "the rule boundaries as a percent of the overall range of values" as I don't know what you mean by that and therefore don't really understand what was wrong.

It is entirely conceivable that it is my own inadequacies in PowerBI that are making this difficult. I inherited it and have been self-learning for the past year or two. Most of the heavy lifting is done in M not DAX  so Ive concentrated on learning Power Query rather than PowerBI. The dashboards were, for the large part, already configured when it came to me and have remained unchanged. 

I thought that changing the way the values were displayed would deliver the required result as it had in other visuals, but they are tables not matrices.

[IanDavies]

I dont know who accepted the solution, but it did not provide a solution to my problem, it just told me that I was wrong and had misunderstood what PowerBi did. none of the examples at the listed URL come close to the use case I demonstarted here.

This is an abuse of the accepted solution system IMO.

[HotChilli · Accepted solution]

It's quite a common misunderstanding this one. You can search the forum for solved similar issues.

Using 'percent' in conditional formatting is not about the data type, it's about

"the rule boundaries as a percent of the overall range of values" which you don't want in this case.

Use a different rule type as here:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color...