Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Apply same dynamic formatting method for a multitude of columns in table

Hi    I have a well prepared source table listing down individual's monthly KPI performance.  The PBI report only need to show the source table.  After the source table is imported, the data looks ...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous 
Here is the sample file updated as requested https://we.tl/t-lqNI1fBWg8

KPI Value = 
IF ( 
    SELECTEDVALUE ( Table1[KPI] ) IN { 2, 3 },
    FORMAT ( SELECTEDVALUE ( Table1[Value] ), "Percent" ),
    IF ( 
        SELECTEDVALUE ( Table1[Year Month] ) IN { "202202", "202203" },
        SELECTEDVALUE ( Table1[Value] ) & "%",
        SELECTEDVALUE ( Table1[Value] )
    )
)