Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Formating a mesure using different mesure

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 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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. 

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    2 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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