Need Help - Disable Drill Through Page Slicers for few visuals in the Drilled Page

[Sky20997]

Hello @Everyone, 

So I have ALL Company Revenue Sheet with Year & Quarter Slicers, and I have a drill through setup for Company Name, so on selecting the Company Name in a table visual, it goes to the detailed Company Page, but the issue is in the detailed Company page, 

I have a ALL YEAR & QUARTER SALES bar chart for that Company along with other visuals, so the external year slicer is affecting this bar chart and only showing one bar for the selected year. I want to disregard the external year slicer for this ALL YEAR & QUARTER SALES bar.

What DAX measure can I use in my Sales Measure so that it shows all the year & Quarter bar trends and disregards the external Year Slicer coming from the Drill Through Page. Need your help.

[Anonymous]

Hi @Sky20997 ,

I create an example and below is the picture I want to show.

As you can see, the metric "All Revenue" is not affected by the slicer selection, and here's the DAX for the measure:

All Revenue =
CALCULATE (
    SUM ( 'Table'[Amount] ),
    'Table'[Category] = "Revenue",
    ALL ( 'Table'[City] )
)

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sky20997]

In this example if I consider, it is Returning 295 as Total Revenue for all cities but I need individual City-wise Revenue and the city slicer should not affect the visual. 

Edit Interactions won't work in my case because I am using Drill Through option.

I have an Year Slicer on it and that Year Slicer is affecting my ALL YEAR & QUARTER WISE Company Revenue BAR Chart in the detailed Company Sheet, hence that bar chart is showing only only one bar graph. 

[ExcelMonke]

Hello,

Based off of your description, have you considered changing the interactions of your slicers? If you select your slicer, then click format in the top ribbon, then click "Edit Interactions" (most left in the ribbon). 

From there, you can select which data visualizaitons the slicer impacts, including tables. 

[Sky20997]

Edit Interactions won't work in drill through sheets, My requirement is when I drill through Company wise in detailed company sheet, I have an Year Slicer on it and that Year Slicer is affecting my ALL YEAR & QUARTER WISE Company Revenue BAR Chart in the detailed Company Sheet, hence that bar chart is showing only only one bar graph. I have tried Edit Interactions but it doesn;t work in other sheets from my understanding.