Text based on a percentage measure

[carbgonpbi]

Hi everyone!

This its the first time I post a new message, usually I find the answer in previous message but I couldn´t find it this time.

I have a table visual in PowerBI that shows the progress of several actions through the year. This table has two value columns (Target, Actual) and another column filled with a measure called "Compliance" that calculates the % of completion (Actual % Target).

Now cames the part I couldnt solve...I need to add a measure that determinates the status depending of the % of compliance of every activity.

The difficult part its that every status category has different % through the year bacause on of the filters of the report its the month of the year (this report its refreshed on a monthly basis after the close month end).

The table that supports every category status and their % through the year its the following:

Month	NUM	Above Target	On Track	Behind Target	Delayed
May	1	4%	3,6%	2,8%	<- Below
Jun	2	9%	8,1%	6,3%	<- Below
Jul	3	15%	13,5%	10,5%	<- Below
Aug	4	22%	19,8%	15,4%	<- Below
Sep	5	30%	27,0%	21,0%	<- Below
Oct	6	39%	35,1%	27,3%	<- Below
Nov	7	48%	43,2%	33,6%	<- Below
Dec	8	58%	52,2%	40,6%	<- Below
Jan	9	69%	62,1%	48,3%	<- Below
Feb	10	79%	71,1%	55,3%	<- Below
Mar	11	89%	80,1%	62,3%	<- Below
Apr	12	100%	90,0%	70,0%	<- Below

So for example in May if an activty has more than 4% of compliance the status should be "Above target" and so on with the different categories and months

This its a quick view of my table:

This is a quick view of my table:

Besides the "Compliance" column should be the status column.

Appreciate your help and time!

[Anonymous]

Hi @carbgonpbi 

Please provide sample data that fully covers your issue and the expected outcome based on the sample data you provided.

Best Regards,

Jayleny