Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help - Highlight graph by Slice

Hi Guys,   I have a challenge that I need to highlight a single section when I select this value from the slice.   For example, the slice is used as date filter then I select January of 2019 and ...
Data Protection
Need Help
Tips and Tricks
danextian's avatar
danextian
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

There are many approaches to this but basically, they make use of a disconnected slicer table (one that has no relationship to fact table) and measures to calculate for the selected items and those that aren't.

 

First create a calculated table. Something like 

Disconnected Table = 
DISTINCT('Fact'[period])


Then create these measures:

SelectedPeriod = 
CALCULATE (
    SUM ( 'Fact'[value]),
    INTERSECT ( VALUES ( 'Fact'[period] ), VALUES ( 'Disconnected Table'[period]) )
)

OtherPeriods = 
SUM ( 'Fact'[value] ) - [SelectedPeriod]

Use these measures in your chart and change the data color as desired.  You will need to use the column from the disconnected table for your slicer.  You may also refer to this tutorial http://sqljason.com/2018/03/highlighting-scatter-charts-in-power-bi-using-dax.html  There is a downloadable sample pbix on the bottom part of the page. 

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

danextian 

 

Thanks for your message,

 

I just checked in this power bi sample, when state (slice) is selected the graph also fiters but what I really need is just to highlight the state selected.

 

 

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    6 years ago

    Hi Anonymous,

     

    Are we looking at the same sample? In the image below, I selected california which highlighted a point in the scattergraph next to it instead of filtering it.  If you don't use a disconnected table, the expected behavior is the slicer or a visual will crossfilter all other visuals.