Conditional formatting highlighting selected value in slicer
I would like to use conditional formatting to highlight a specific bar in my bar chart, based on the value I have selected in my slicer. All over the internet, I find the same DAX formula which is the following: HighlightCompany = IF( SELECTEDVALUE(Company[CompanyName]) = MAX(Company[CompanyName]), 1, // This means the company is selected, and it will be highlighted 0 // This means the company is not selected ) Although, when I do this DAX formula, all bars are highlighted. I thought it might've been because my slicer is not filtering the bar chart, although when I choose to filter the bar chart, it only shows the selected company in the bar chart, without all the other companies. Here are some pictures: In this one, the selected company (on the left) only returns that company in the bar chart (on the right). In this one, the selected company (on the left) returns all companies on the right, without highlighting the selected company. When I use a dax formula, either one of both pops up, and not a combination of both. Does anyone have the same issue or have a solution for this problem? Thank you in advance!
