Display Dollars and Percents on a Waterfall Chart

[Swish11]

I am requesting assistance on whether it is possible to display both the $ amount and the % for each change in the waterfall chart. I created a manual table, with measure name and index number, which is used in a switch calculation to display the correct amounts on the chart.

WaterfallDValue = SWITCH(
    SELECTEDVALUE(WFDirect[Index]),
        1,[YTD_WF_D_ExpiringMarked],
        2,-[YTD_WF_D_Lost],
        3,-[YTD_WF_D_LO],
        5,+[YTD_WF_D_Rate],
        6,+[YTD_WF_D_N],
        7,+[YTD_WF_D_NO],
        8,+[YTD_WF_D_O],
        BLANK()
)

I created an additional field specific to the %. I attempted to add this as a tooltip but the % appeared in all the columns instead of the specific one, i.e. the new% showed on the lost $ column.

WaterfallD% = SWITCH(
    SELECTEDVALUE(WFDirect[Index]),
        1,[YTD_WF_D_ExpiringMarked],
        2,-[YTD_WF_D_Lost]/[YTD_WF_D_ExpiringMarked],
        3,-[YTD_WF_D_LO]/[YTD_WF_D_ExpiringMarked],
        5,+[YTD_WF_D_Rate]/[YTD_WF_D_ExpiringMarked],
        6,+[YTD_WF_D_N]/[YTD_WF_D_ExpiringMarked],
        7,+[YTD_WF_D_NO]/[YTD_WF_D_ExpiringMarked],
        8,+[YTD_WF_D_O]/[YTD_WF_D_ExpiringMarked],
        BLANK()
)

Is there any way to have the $ and the % appear on the chart?

[v-chuncz-msft · Accepted solution]

@Swish11 

You may try adding FORMAT.

https://community.powerbi.com/t5/Desktop/Reading-different-data-types-in-the-same-table-from-Excel/m...