topic Re: Dax Measure to identify completed milestones in DAX Commands and Tips

Dax Measure to identify completed milestones

Anonymous — Sun, 24 Apr 2022 09:21:35 GMT

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!

Re: Dax Measure to identify completed milestones

Fowmy — Sun, 24 Apr 2022 10:08:06 GMT

Anonymous

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

Re: Dax Measure to identify completed milestones

Anonymous — Sun, 24 Apr 2022 10:22:41 GMT

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?

Re: Dax Measure to identify completed milestones

Fowmy — Sun, 24 Apr 2022 10:31:32 GMT

Anonymous

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

Re: Dax Measure to identify completed milestones

Anonymous — Wed, 27 Apr 2022 06:57:41 GMT

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.