Forum Discussion
Anonymous
4 years agoNot applicable
Select different graph with the same slicer
Hello Community,
I have a slice and a line chart, I have the good results when selecting zones from my slicer one by one, but when selecting all it does not showing me the right data because I should be sourcing to other data, I want to know is it possible to use the same slicer, but using in the same line chart two different calculations ?
Thanks in advance
1 Reply
- amitchandakSuper User
Anonymous , isfiltered and hasonevalue can help you
if(isfiltered(Table[Column]), [Measure1], [Measure2] )
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/