Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a calculated measure I use to determine what percent of productivity has been met by staff in my organization. I use a measure to determine this with the following formula:
Target Hours Met % = sum(DirectService[Consumer Hours])/[Target Hours Total]
The calculation works fine, however when I add it into a Matrix or into a Table: Values and attempt to do Conditional formatting: Background color scales, it does not put the colors in. For whatever reason, the Data bars Conditional formatting does work, but not the Background color scales and not the Font color scales. Here's how they look. 1) The one cell table, 2) The Conditionalformatting options that are shown as available, 3) How I attempt to enter the background colors, which is accepted, but which does not actually show up on 1), 4) How I enter the Data bars conditional formatting, which does work as shown in 5).
I've tried all of the different options in the Background color scales and nothing has worked, It does show up under the Remove conditional formatting: Background color scales. So I can add and remove the conditional format, it just doesn't show up in the cell.
Solved! Go to Solution.
Hi @astevens,
Did you use a single value in the table visual? I would suggest using the custom visual "Card with states by OKViz" instead.
Best Regards,
Dale
Hi @astevens,
Did you use a single value in the table visual? I would suggest using the custom visual "Card with states by OKViz" instead.
Best Regards,
Dale
This did work for me, using the OKViz custom visual. Still can't get the conditional formatting to work on the regular matrix/table visuals, but the custom OKViz was a decent work around. Thank you.
Accually, conditional formatting (rules, color scale, field value) still not works (apr 2019 desktop version) in case you have several measures in rows in a matrix:
There would be great to have this working
Accually, conditional formatting (rules, color scale, field value) still not works (Version: 2.68.5432.841 64-bit apr 2019 version).
This answer https://community.powerbi.com/t5/Desktop/Conditional-Formatting-not-working-for-one-row-table/td-p/6... did not work too.
I have done the same no issues at all. What version of PBI desktop are you using?
Regards'
Erich Dejesus
I am having the same problem. I have created 3 measures (1 target and 2 current rates) and put these in to a table. When I try to add font or background conditional formatting to them, neither work. What did you do to overcome this? It's so frustrating!
Version: 2.53.4954.481 64-bit (December, 2017)
Hmm, that's interesing, I created a % measure and tried this and did not have any issue with any of the conditional formatting.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |