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...
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

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