Forum Discussion
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.
Anonymous , Try using below measure
KPI selected formatted =
VAR SelectedKPI = SELECTEDVALUE('KPI list'[Order])
RETURN
SWITCH(
SelectedKPI,
1, FORMAT([CA], "0.00"),
2, FORMAT([UC], "0.00"),
3, FORMAT([DN], "0.00%"),
4, FORMAT([DV], "0.00%")
)
Hello, i have already tried to do this and it works in table and matrix but when it's in graph i can't use it because power bi think the mesure is a format text