Forum Discussion
Table conditional formatting based on column not displayed
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 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.
joaoribeiro Sorry if I confused you! In reality I have 2 fields:
Del_Solution_Proposal and Solution proposal (value derived from the first column). Now what I would like is to display only the first column and format it based on 1 or 1-Not started --> red, 3 or 3-Completed --> green.
If I conditional format based on first column I do not have option to set 1-Not started as the criteria
If I conditional format based on second column without displaying it it does not work for all lines
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.
joaoribeiro Thanks a lot but unfortunately I am not allowed to share the PBIX file
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