Forum Discussion
Fixing a Conditional Format that is used when drilling down
On my report, I have two tables. The FIRST TABLE has the categories & subcategories (e.g. COUNTRIES + CITIES).
the SECOND TABLE has the attendance level for different webinars that are associated with each CITY.
The logic behind the conditional formating is if the attendance for the webinars is 0% to less than 90%, then the background will turn blue for that webinar.
This conditional formating works fine on the SECOND TABLE. However, when I click on the FIRST TABLE to filter the results by CITY, the conditional format breaks. The background will show blue but the attendance percentage for that city 95% or sometimes greater.
Is there a reason why this conditional formatting isn't formatting based on the percentage value? And is there a way to fix this?
4 Replies
- v-gizhi-msft
Community Support
Hi,
After my test, it works well here:
I create a measure first:
Color = IF(MAX('Level'[Level])<0.9,"#00AAFF")Then apply this measure to the [Webinars ID] column background:
After choose city slicer, it still works well here:
Please check your conditional formatting configuration.
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto Zhi
Hi Giotto,
Is it possible to create a calculated measure in the color measure?
I ask because the TABLE 1 & TABLE 2 that I had mentioned are both visualization tables and not data tables.
Would you know how to make this conditional formating work, given this circumstance; or must I do something different like create a data table that will calculate the percentage of attendance for each WEBINAR by CITY and then grouped by COUNTRY?
- v-gizhi-msft
Hi,
I am confused about how your visualization tables generated.
Could you please share some sample meta data about your data tables?
Thanks!
Best Regards,
Giotto Zhi
