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!
Add Highlight-Functionality for Line- & Scatter Charts to Interactions
When making selections in Time-Series (Line-Charts) with the rectangular lasso, interactions with other Line-Charts can only be set to "Filter" or "Off" but not to "Highlight". As a result, a selected region (by lasso) from Figure A only shows the filtered data in Figure B, loosing the overall context within Figure B. To maintain the context from Figure B, it would be very helpful if the interaction could be set to "highlight". This functionality is already intrinsically implemented: Line charts with legend-grouping can be highlighted when clicking on a single/multiple legend-groups (see below: only "LAS|R" selected/highlighted) See another example from a statistical software which has this functionality: The screenshot plots the same y-data over different (production-)timestamps. The data is interactively filtered by a "rectangular lasso" within the third-row-figure (see dashed rectangle). As a result, the corresponding points in all the other figures are highlighted, too. (In addition, you can move around the rectangle and the highlighted data adapts instantaneously) Line charts with lines-only could be highlighted with the help of an indicator variable which is set as legend, allowing to compare "selected"-group vs. "non-selected"-group lines.
