I am working on designing a solution and need help.
There are two facts table: Data and Target.
For certain KPIs, I need to compare Yearly/Monthly/Daily actual vs target. I am looking for applying conditional formatting using DAX. I am partial successful in the case if all the target comparision are either "Higher the better" or "Lower the Better". But if I want to dynamically apply the conditional formatting based on the filter selection, then how should I do it?
At present, I am using following DAX for conditional formating:
I have created a KPI table with the list of all available KPIs categories and sub-categories. I have included another column for flag for Lower the better. Using this table, I would like to drive the KPI color selection for Higher the Better or Lower the better.
Thank you for your response. I have tried using both the DAX shared but I am not able to select the DAX under Format by - Field Value option (Conditional Formating). The DAX appears to be greyed out or something like that.