Dax Measure to identify completed milestones

[Anonymous]

Hi, 

I want to show a table with milestones.  The milestones that are 'Done' should be greyed out. Is there a way to do this with a Dax measure? The name of the column with the status info is 'Status Milestone 1'. Besides 'Done', there is the option to choose 'In progress' or 'New'.

Thanks for your recommendations! 

[Fowmy]

@Anonymous 

Need more details along with your question. Have you tried the conditional formatting options?

[Anonymous]

Hi @Fowmy . Thanks for responding. In the meantime, I managed to create a new measure with DAX: 

Measure = CONTAINS('name table XYZ','name table XYZ'[Status Milestone 1], "done"). I now have a new column with False and True. Can I use this measure for conditional formating of the milestone name column? 

If 'True' then the 'milestone name' = light grey. Is this possible? 

[Anonymous · Accepted solution]

Hi @Anonymous ,

In addition to Fowmy's reply, I will create a sample to help you achieve your goal.

Measure:

Measure = IF(MAX('Table'[Milestones]) = "Done","Grey")

Result is as below.

I think Color-code based on text is a good way for your situation.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@Anonymous 

Yes , it's possible, please refer to this guide: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting