cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Likhitha Member
Member

Doubt regarding highlighting bar

Hi All,

I'm having few weeks data with sales,I put that on bar chart.I want to highlight Maximum week number bar.How to do that?

Every bar should be of same colour,but the maximum week number bar should be highlighted differently.

1 ACCEPTED SOLUTION

Accepted Solutions
Likhitha Member
Member

Re: Doubt regarding highlighting bar

Hi All,

I found the solution.In my scenario i'm using combo chart.So,that i can do conditional formatting for X-Axis.

I created a measure  which is

WeekSelected=selectedvalue(Date[week])
Then Again I created a new measure
Colour Coding=
var Highestweek=maxx(allselected(Date[Week]),WeekSelected)
return
if(WeekSelected=Highestweek,"#FF0000")

Thanks All 🙂


@Likhitha wrote:

Hi All,

I'm having few weeks data with sales,I put that on bar chart.I want to highlight Maximum week number bar.How to do that?

Every bar should be of same colour,but the maximum week number bar should be highlighted differently.


 

View solution in original post

4 REPLIES 4
JirkaZ Regular Visitor
Regular Visitor

Re: Doubt regarding highlighting bar

@Likhitha You can only try to use the custom formatting --> Format by: color scale and choose colors for Minimum and Maximum values. The danger is that depending on the total values, more than one columns can be highlighted as the maximum.

Likhitha Member
Member

Re: Doubt regarding highlighting bar

@JirkaZ  I can't opt that option.Because it is line and clustered column chart and there is no conditional formatting for Data colours

Community Support Team
Community Support Team

Re: Doubt regarding highlighting bar

Hi @Likhitha ,

 

Your demand is a good idea, while it is not supported to set conditional formatting for line and clustered column chart in Power BI currently. You can post your new idea in Idea Forum , to improve the Power BI.

 

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,

Amy

 

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

 

Likhitha Member
Member

Re: Doubt regarding highlighting bar

Hi All,

I found the solution.In my scenario i'm using combo chart.So,that i can do conditional formatting for X-Axis.

I created a measure  which is

WeekSelected=selectedvalue(Date[week])
Then Again I created a new measure
Colour Coding=
var Highestweek=maxx(allselected(Date[Week]),WeekSelected)
return
if(WeekSelected=Highestweek,"#FF0000")

Thanks All 🙂


@Likhitha wrote:

Hi All,

I'm having few weeks data with sales,I put that on bar chart.I want to highlight Maximum week number bar.How to do that?

Every bar should be of same colour,but the maximum week number bar should be highlighted differently.


 

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)