Solved: selective slicer

doppietta · ‎12-13-2017

Hi all,

I need to plot on clustered column chart the range distribution twice: the first one is the unfiltered version (made of by all the records in the table) and I need the second one to be dynamically adjustable based on a time slicer (I have a datetime column on my data model).

I don't know how to create a slicer that interacts only with the second dataset and not with the first one.

Thank you.

Regards,

Alberto

Eric_Zhang · ‎12-13-2017

@doppietta wrote:

Hi all,

I need to plot on clustered column chart the range distribution twice: the first one is the unfiltered version (made of by all the records in the table) and I need the second one to be dynamically adjustable based on a time slicer (I have a datetime column on my data model).

I don't know how to create a slicer that interacts only with the second dataset and not with the first one.

Thank you.

Regards,

Alberto

@doppietta

You can disable the interaction between slicers and other charts. See Visualization interactions in a Power BI report

View solution in original post

Eric_Zhang · ‎12-13-2017

@doppietta wrote:

Hi all,

I need to plot on clustered column chart the range distribution twice: the first one is the unfiltered version (made of by all the records in the table) and I need the second one to be dynamically adjustable based on a time slicer (I have a datetime column on my data model).

I don't know how to create a slicer that interacts only with the second dataset and not with the first one.

Thank you.

Regards,

Alberto

@doppietta

You can disable the interaction between slicers and other charts. See Visualization interactions in a Power BI report