Forum Discussion

sdc's avatar
sdc
Helper I
5 years ago
Solved

Multiple date fields on one report

I have one data set which contains data for multiple months and would like to add two bar charts beside each other for a quick comparisson (this month vs last month, see screenshot):     The...
  • Pragati11's avatar
    5 years ago

    Hi sdc ,

     

    Try modifying EDIT INTERACTIONS for your charts.

    Consider following report page: I have got a MONTH filter here on the right.

     

    Now suppose I want this filter to work only on the 3rd Table from left, I can modify it's interactions as follows:

    1. Click on MONTH slicer
    2. Under FORMAT options on the top ribbon, select Edit Interactions 

       

    3. Once you click on edit interactions you will see following: 

       

    4. Now you see 2 icons on the top right of all the 3 tables.
    5. Click on circular icon to stop that table visual from getting filtered from the MONTH slicer.

     

    Once that is done, 1st and 2nd tables from left, don't get filtered on selecting values from the MONTH slicer as shown below:

     

    So if you see the above GIF, only the 3rd table is getting filtered from the SLICER, not the other 2 from the left.

     

    Apply similar kind of edit interactions in your case for both the slicers.

     

    For more details on Edit Interactions refer following:

    https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

     

    Thanks,

    Pragati