How do you conditionally highlight a bar in a Power BI Report?

There are different interactions Power BI visuals can have, but how do we conditionally highlight a bar in a Power BI report using a slicer? Patrick shows you some MAGIC to get this to work.


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #ConditionalFormatting #GuyInACube

[cedartree]

3 years old and STILL a life saver. Brilliant. Been struggling with this for hours until I found this video. I'm using it in a custom data label, but it all still applies. Thanks guys!

[leksdic]

I am FLATTERED that my question was your weekend! When I saw the thumbnail i could hardly point and click from excitement. Thanks a lot.
Oh, all the ideas i have now! xD

(Next goal, highlight single points in a LINE chart. Max, mins, importan dates in the line chart etc.)

[sben]

You are a life saver. Thank you all the team !

[ghada]

Life saver!!! Spent so many hours to figure it out. Before, I used the non related table slicer to highlight then created calculated measures to pass the slicer selection to other visualizations using Treatas function. But syncing the two slicers is awesome. THANK YOU!

[pawewrona]

I thought this is easy task from DAX perspective, but I love how Adam improved it. Amazing.

[jtmh]

As always, Patrick. You bring the amazing in Power BI. I can't tell you how many times I use your tips in the Desktop application. Please keep up the great work!

[paulrockliffe]

This is cool, love that you can do it, but I think it's crossed a line into "It shouldn't be that complicated" territory.

Anyway, your timing is perfect as I spent last week grappling with a similar problem; Slicers filter, visuals filter, users don't care that they're different things.

I have a page that is essentially letting the user select a single value to go and explore. There's 2000 values to choose from. Slicers are great if you know which one you want, visuals are great if you want to select the one with the most x or the most y or the one that changed the most in the last 12 months, etc.

But what if you want to do both? Filter your 2000 choices to 10 by picking from visuals or other slicers - slicer to a region or country, visual to find the ones where turnover was greater than x, back to the slicer to pick your final value. It's missing the ability for visuals to filter slicers.

I can get a single value in a Visual, but still need to find it in the slicer, or I can get it in the slicer, but still need to click it in the visual to select it. It works, but it doesn't work for my users. It looks like this is broadly in the right place to solve that, though I've not tried yet.

Can you do that?

[scottbryner]

It's always cool when you're able to solve a problem with an elegant solution. Nice work!

[marianscipa]

Hey Patrick. This looks great but where can I find the full DAX for the measure you created in this vid? It seems incomplete on screen and does not work on my end. Thanks

[vinayshyamparankusham]

This is amazing and very clever. I have been trying to do the exact same thing from the last few weeks with no luck. I am new to Power BI and posted on few community support forums with not much luck. I was told that disconnected table is the only way but it breaks other visualisations on the page. You have made my day. I have learnt a lot by watching your videos in the last couple of months. Thanks a ton.

[yassirkhalid]

I like the idea, but I must watch the video again and again to master it

Honestly, I'd love to watch the video for the way it was presented!

[bevp]

I was trying to work out how to do this EXACT situation in a project I'm working on. Thanks so much for putting this video together!

[mknights]

The solution is great and is going to be useful ... there was a much more powerful lesson here for me.
1) stick at the problem despite it seeming impossible.
2) from an initial idea your colleagues swarmed in, lifting the solution to success by bringing their own innovations.
That I think is the essence of great teams and is a powerful reminder to the benefits of staying true to that way of working. Thanks.

[Bharath_PBI]

That's cool. I had disconnected tables but had used treatas in my report measures. Sync slicers trick is awesome. Thanks for the trio 👍

[alphamaniac]

Great collab effort. Pooling great minds really get things done!

[jdstein]

This is completely fantastic, plus I love the way you made sure to include "usability" into your design, since two identical (to the user) slicers wouldn't meet anyone's design standards.

[dominikrastetter]

That's amazing! Thank you, Patrick!

[TheBebwa]

This is great. Is it possible to then have the highlighted bar(s) appear first before the the rest of the columns?

[nehachak]

Hi Patrick.. you always have a solution for any problem... that's so awesome! Can you please share some tricks for creating 3D bar charts?

[calumrankine]

Here’s one for you!

In a call centre environment, I have a dataset that lists every change in “code” a sales agent uses. I have a time column and a date column and I’d like to add in a column that numbers the rows in each day (chronologically of course) based on whether another column is 1. This will allow me to see the first code used by the agent on a certain day and the time it took place