Forum Discussion

doppietta's avatar
doppietta
Frequent Visitor
8 years ago
Solved

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


    doppietta

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

1 Reply

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft 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


    doppietta

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