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

Thanks joaoribeiro for getting back to me. In my data I have a value Deliverable status with 2 values. I have created a second column that returns only the corresponding number (decimal format). Now in my table visual I want to have the first column with a green or red background depending if the value is 1 or 2 but I do not want to display the column with the 1 or 2 values:

When adding only the first column in the visual, the conditional format is applied to some lines but not all. As soon as I add the second column in the visual, it works for all lines.