Forum Discussion

DHeller's avatar
DHeller
Advocate I
3 years ago
Solved

Table conditional formatting based on column not displayed

I want to conditional format a table column based on a column that I do not want to display. It works for some of the lines but for others the conditional format only gets applied if I add the "unwan...
Need Help
  • joaoribeiro's avatar
    joaoribeiro
    3 years ago

    DHeller that's ok. Try to create a Measure to retrieve the latest status from the first column using CALCULATE/MAX, something like that. This way you will have an unique value and then I believe you will be able to use it as text in the conditional formatting.

     

    Unfortunately I cannot help much more without the sample of data/pbix. Sorry about that!

     

    Hope this answer solves your problem!
    If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, please consider marking it as a solution ✔️or giving it a kudoe 👍

    Thanks!

    Best regards,
    Joao Ribeiro

DHeller's avatar
DHeller
Advocate I
3 years ago

joaoribeiro Thanks for input. I seems I do not have the same options to configure my conditional formatting (I don't have the value only). I am using PowerBI desktop.

 

joaoribeiro's avatar
joaoribeiro
Impactful Individual
3 years ago

DHeller, please try to change the "Based on field" value to your "Deliverable Status" column, and change the "Summarization" option to "First" instead of "Count". This way, you should have the option to put specific text values 🙂

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️or giving it a kudoe 👍

Thanks!

Best regards,
Joao Ribeiro