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.

joaoribeiro's avatar
joaoribeiro
Impactful Individual
3 years ago

Hi DHeller , thanks for the explanation. Can you please share how is your conditional formatting configured?

Also, why don't you use the first column and the column assigned to the rule? This way you can set background color rules for each text value in the "Deliverable status" column. Check the example below:

 


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