Creating a KPI Dashboard using only one SQL table with 100+ measures

Dear all

I am trying to create a KPI Dashboard in Power BI using an SQL table which has over 100 measures setup. The 3 fields highlighted all have the same values.

The data type in the KPI value field is a mixture of number,% and £ but I couldn’t get the right format for % as they were all decimals.

So I created two additional columns (KPI value% and KPI value No). I need a column that holds all the data types but can also be used for visuals as all the formulas I have to create a new column make the column text.

Each measure has to have a single line of visuals which show KPI name, a score card for the value, direction of travel and a trend line and look something like below.  I would need target not to appear if there is no target set.

I want to be able to refresh Power Desktop and everything updates automatically and I only want to have one table in Power Bi along with the date table which supplies the data to all the visuals.

Can anyone please help?