With the KPI object, leave the Expression field blank and place your text in the label field. To get rid of the dash '-' change the colour to white. Final step is to expand the Appearance section and set the 'Link to sheet' option.
Downside is the format of the label text cannot be changed so the other option is, as you have mentioned, to use a text box with a hyperlink to the respective sheet.
Hope this helps.