chart options

Hi swathrddy ,

I’d like to acknowledge the valuable input provided by the amitchandak  and Shravan133 . Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue. 

You can create two calculated columns that convert the Actual and Target fields from text to numbers.

Num_Actual =
SWITCH('Table'[KPI Actual],
"Yes",1,
"No",0)

Num_Target =
SWITCH('Table'[Target],
"Yes",1,
"No",0)

Then put it into a suitable visual object. For example line charts, KPIs.

A visualization is an image created from data. Visualizations are also called "visuals." Some examples of visuals are: pie chart, line chart, map, and KPI. This article lists visualizations available in Power BI.

Visualization types in Power BI - Power BI | Microsoft Learn

This article provides a quick introduction to creating a visualization in a report.

Add visualizations to a Power BI report (part 1) - Power BI | Microsoft Learn

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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