Forum Discussion

DHeller's avatar
DHeller
Icon for Advocate I rankAdvocate 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
Icon for Advocate I rankAdvocate I
3 years ago

joaoribeiro The Del_Sol Proposal is the field I am interested in my case. In the conditional formatting it comes automatically with Count... I can only change summarization to count distinct. I can change to First if I select format by field value but then I do not have any option to format...

Is there someting wrong with the format of that column? It is currently set as Text data type...

 

 

joaoribeiro's avatar
joaoribeiro
Icon for Impactful Individual rankImpactful Individual
3 years ago

DHeller Thank you.

 

Just to understand, you are interested in changing the background color of the "Del_Sol Proposal" bases on "Deliverable Status" value, right? If so, proceeed as suggested and use the "Deliverable Status" in the conditional format.

 

If not, please explain again which rule you want to follow for the conditional formatting.

 

Looking forward to hearing from you.