Forum Discussion
selective slicer
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 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
You can disable the interaction between slicers and other charts. See Visualization interactions in a Power BI report
1 Reply
- Eric_ZhangMicrosoft Employee
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
You can disable the interaction between slicers and other charts. See Visualization interactions in a Power BI report