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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SteveIOW
Helper II
Helper II

Conditional format a bar chart over 75th Quartile

Hi All,

 

I have a bar chart in which I want to colour the bars of the chart for all the values over the 75th quartile.

 

any ideas please?

 

the quartile I am calculating as VAR _A =
SUMMARIZE (
'MainFacts',
'MainFacts'[ProvCode],
'MainFacts'[p_spell_id],
"MaxRwCnt", MAX ( MainFacts[RwCnt] )
)
RETURN
PERCENTILEX.INC ( _A, [MaxRwCnt], .75 )

1 ACCEPTED SOLUTION
v-yanjiang-msft
Community Support
Community Support

Hi @SteveIOW ,

According to your description, I create a sample.

vkalyjmsft_0-1660631747692.png

And create a measure as you mentioned.

vkalyjmsft_1-1660631786605.png

vkalyjmsft_2-1660631903095.png

Now for example in the bar chart RwCnt by p_spell_id, if we want to color the bar based on whether the RwCnt greater than the Quartile 7.25. Here's my solution.

1. Create a measure.

 

Color =
IF (
    MAX ( 'MainFacts'[RwCnt] ) >= CALCULATE ( [Quartile], ALL ( 'MainFacts' ) ),
    "Red",
    "Green"
)

 

Then in the visual format setting pane, select Bars>Colors>fx.

vkalyjmsft_3-1660632745403.png

Select the measure in the field dialoge.

vkalyjmsft_4-1660632813702.png

Get the correct result.

vkalyjmsft_5-1660632922140.png

I attach my sample below for your reference.

 

Best Regards,
Community Support Team _ kalyj

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

2 REPLIES 2
v-yanjiang-msft
Community Support
Community Support

Hi @SteveIOW ,

According to your description, I create a sample.

vkalyjmsft_0-1660631747692.png

And create a measure as you mentioned.

vkalyjmsft_1-1660631786605.png

vkalyjmsft_2-1660631903095.png

Now for example in the bar chart RwCnt by p_spell_id, if we want to color the bar based on whether the RwCnt greater than the Quartile 7.25. Here's my solution.

1. Create a measure.

 

Color =
IF (
    MAX ( 'MainFacts'[RwCnt] ) >= CALCULATE ( [Quartile], ALL ( 'MainFacts' ) ),
    "Red",
    "Green"
)

 

Then in the visual format setting pane, select Bars>Colors>fx.

vkalyjmsft_3-1660632745403.png

Select the measure in the field dialoge.

vkalyjmsft_4-1660632813702.png

Get the correct result.

vkalyjmsft_5-1660632922140.png

I attach my sample below for your reference.

 

Best Regards,
Community Support Team _ kalyj

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

that is brilliant - thank you so much for your help!

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors