Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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
Solved! Go to Solution.
@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
@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