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
suyogbi
Frequent Visitor

Alternating colours for BAR Graph with single measure without any conditional formatting

Hi All,

 

I have a requirement where i need to show alternating colour in bar graph which has only single measure (salesamount) in Values and the AXIS(Customer) around 5000 Customer. there is no condional formatting requirement, just need to show 2 diff colours in alternating format.

 

any work around for this?

 

Thanks in Advance.

Suyog

1 ACCEPTED SOLUTION

@suyogbi , Try like  

sales amount

Rank = rankx(allselected(Table[Customer]), [sales amount])

 

// sales amount is a measure  

 

Color = 

var _1 = mod([Rank],2) 

return 

if(_1,=1, "Blue", "Green")

 

You need use conditional formatting using field value option with this measure 

View solution in original post

5 REPLIES 5
amitchandak
Super User
Super User

@suyogbi , No, you have to use conditional formatting to get this.

 

May be create a rank on customer and measure and use mod with 2 and us that in conditional formatting

@amitchandak how can we achieve this with conditional format?  i just need to show alternating colour bars. i dont have any specific condition. 

@suyogbi , Try like  

sales amount

Rank = rankx(allselected(Table[Customer]), [sales amount])

 

// sales amount is a measure  

 

Color = 

var _1 = mod([Rank],2) 

return 

if(_1,=1, "Blue", "Green")

 

You need use conditional formatting using field value option with this measure 

@amitchandak  how to handle the ties here? ties are giving same color in graph.

both skip and dense not helping .. 

 

@amitchandak  Thank you so much. this solves my requirement.😊 cheers.. 👍

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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.