Forum Discussion

Saibal_78's avatar
Saibal_78
Icon for Helper I rankHelper I
3 years ago

Multiple KPIs with line break using BUTTON and SHAPE

Hi All,   I am trying to create a custom multiline KPIs using button/shape, below are my DAX codes, note I am not using card as left alignment is not possible in card. Any help would be highly appr...
Need Help
rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Saibal_78 

 

You can use the following DAX measure:

VAR SummaryText =
    KPI1_Text & REPT(Space,KPI1_NumberOfSpaces_Left) & KPI1_Value & REPT(Space,KPI1_NumberOfSpaces_Right) &UNICHAR(10)&
    KPI2_Text & REPT(Space,KPI2_NumberOfSpaces_Left) & KPI2_Value & REPT(Space,KPI2_NumberOfSpaces_Right) &UNICHAR(10)&
    KPI3_Text & REPT(Space,KPI3_NumberOfSpaces_Left) & KPI3_Value & REPT(Space,KPI3_NumberOfSpaces_Right) &UNICHAR(10)&
    KPI4_Text & REPT(Space,KPI4_NumberOfSpaces_Left) & KPI4_Value & REPT(Space,KPI4_NumberOfSpaces_Right) &UNICHAR(10)&
    KPI5_Text & REPT(Space,KPI5_NumberOfSpaces_Left) & KPI5_Value

 

UNICHAR(10) gives a line break.

Please let me know if this didn't help.