Forum Discussion
Conditional Formatting not applying as expected when using Percentages
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:
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.
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.
