Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
joseama1
Regular Visitor

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??
 
 
1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @joseama1 ,

I created some data:

vyangliumsft_0-1719885869679.png

 

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

vyangliumsft_1-1719885869680.png

Format style – Field value

What field should we base this on – [Color]

vyangliumsft_2-1719885909731.png

3. Result:

vyangliumsft_3-1719885909733.png

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

View solution in original post

1 REPLY 1
v-yangliu-msft
Community Support
Community Support

Hi  @joseama1 ,

I created some data:

vyangliumsft_0-1719885869679.png

 

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

vyangliumsft_1-1719885869680.png

Format style – Field value

What field should we base this on – [Color]

vyangliumsft_2-1719885909731.png

3. Result:

vyangliumsft_3-1719885909733.png

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.