topic Re: Formating a mesure using different mesure in DAX Commands and Tips

Formating a mesure using different mesure

Anonymous — Mon, 15 Jul 2024 10:27:17 GMT

Hello everyone,

In a project i would like to use different mesure in a single one but i have some difficulties to do it.

For exemple in my dataset i have 4 mesure CA and UC in decimal and DN and DV in percentage. I created a new table KPI list with my KPI name and a column order.
I would like to calculate a new mesure KPI selected :

KPI selected =

VAR SelectedKPI = SELECTEDVALUE('KPI list'[Order])

RETURN

SWITCH(

SelectedKPI,

1,[CA],

2,[UC],

3,[DN],

4,[DV],
)

The point is to have a segment KPI list and when i select CA or UC my bar chart use the KPI selected and he is in decimal and when i select DN or DV the barchart is now in percentage.

Is this possible ?

Thank you

Re: Formating a mesure using different mesure

bhanu_gautam — Mon, 15 Jul 2024 10:34:00 GMT

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%")
    )

Re: Formating a mesure using different mesure

Anonymous — Mon, 15 Jul 2024 11:41:28 GMT

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

Re: Formating a mesure using different mesure

Anonymous — Tue, 16 Jul 2024 03:23:48 GMT

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.