Forum Discussion

joseama1's avatar
joseama1
Regular Visitor
2 years ago
Solved

Create a Measure based on a dynamic slicer selection

Hello Guys!

 

let me put some backgoud first , im  putting a color rule on a bar chart base on  the following condition

Column ColorOAE = IF( AVERAGE('OAE'[C01_2M])>= [MTARGETOAE] , "#0F0", "#F00")
Column ColorOAE is the measure that i use  as function to put the color in the chart , green if is above  MTARGETOAE and red if is below.
everything works fine if i were only showing the values of  'OAE'[C01_2M] , but in my chart i have a dynamic Y axis , depending on a slicer that could select
all this options
C01_2M
C02_CLAMSHELL
C03_4M3
C05_4M1
C06_CELDA_6
C07_CELDA_7
C08_CELDA_8
C09_CELDA_9
C10_CELDA_10
C12_FUJI
C13_CANNING_1
 
how can i change this measure  to achive what i want??
 
 
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  joseama1 ,

    I created some data:

     

    Here are the steps you can follow：

    1. Create measure.

    Avg =
AVERAGEX(
        'Table','Table'[Value])
    Color =
IF(
    [Avg]>=[MTARGETOAE],"#0F0", "#F00")

    2. Column – Color –fx

    Format style – Field value

    What field should we base this on – [Color]

    3. Result:

    If the above results do not meet your expectations, can you express the expected results in the form of a picture, we can help you better

     

    Best Regards,

    Liu Yang

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi  joseama1 ,

    I created some data:

     

    Here are the steps you can follow：

    1. Create measure.

    Avg =
AVERAGEX(
        'Table','Table'[Value])
    Color =
IF(
    [Avg]>=[MTARGETOAE],"#0F0", "#F00")

    2. Column – Color –fx

    Format style – Field value

    What field should we base this on – [Color]

    3. Result:

    If the above results do not meet your expectations, can you express the expected results in the form of a picture, we can help you better

     

    Best Regards,

    Liu Yang

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