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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Likhitha
Helper IV
Helper IV

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
Likhitha
Helper IV
Helper IV

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
Likhitha
Helper IV
Helper IV

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.


 

v-xicai
Community Support
Community Support

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.

 

JirkaZ
Solution Specialist
Solution Specialist

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

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.