Formating a mesure using different mesure

Hi Anonymous ,

Thanks bhanu_gautam  for the quick reply and solution. You can place the measure provided by bhanu_gautam  on the data label of the column chart.

Or we can create dynamic format strings for measure.

Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn

KPI selected = 
VAR SelectedKPI = SELECTEDVALUE('KPI list'[Order])
RETURN
    SWITCH(
        SelectedKPI,
        1,[CA],
        2,[UC],
        3,[DN],
        4,[DV]
    )

SWITCH(SELECTEDVALUE('KPI list'[Order]),
1,"0.00",
2,"0.00",
3,"0.00%",
4,"0.00%")

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.