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

joaoribeiro's avatar
joaoribeiro
Impactful Individual
3 years ago

DHeller Thank you for making it clear! I see now. Is it possible to share the PBIX file (can be as private message if you prefer)? So I can take a look in the data model? At first glance, for me it's weird that you cannot use the first column and set specific values in the formatting.

DHeller's avatar
DHeller
Advocate I
3 years ago

joaoribeiro Thanks a lot but unfortunately I am not allowed to share the PBIX file

 

  • joaoribeiro's avatar
    joaoribeiro
    Impactful Individual
    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 a lot for your support. For time being I will handle with icons based on the number value rather than coloring the text values. Once I have more time I will continue investigations. Thanks again!