Forum Discussion

vivran22's avatar
vivran22
Icon for Community Champion rankCommunity Champion
7 years ago
Solved

Customized Conditional Formatting (Using DAX)

Hi,   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...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago
    I had the same issue, forgot to mention you need to transform your column where you define lower is better to number.

    Referring to the column on the measures selection.

    Regards,
    MFelix
vivran22's avatar
vivran22
Icon for Community Champion rankCommunity Champion
7 years ago

MFelix 

 

Hi,

 

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.

 

Please advise.

 

Thanks,

Vivek

MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago
I had the same issue, forgot to mention you need to transform your column where you define lower is better to number.

Referring to the column on the measures selection.

Regards,
MFelix
  • vivran22's avatar
    vivran22
    Icon for Community Champion rankCommunity Champion
    7 years ago
    Thanks! It worked.

    Rgds,
    Vivek