0

I need a slicer which will override the drill through filter or even disable it if possible.

I have a report where I am using a DAX measure to calculate SUM(Sales) for consumer segment in a card visual.

Here's the DAX measure.

SalesForConsumer =
CALCULATE(SUM(Orders[Sales]),Orders[Segment] = "Consumer")

enter image description here

After applying drill-through to the card, this is how drill-through page looks with page level filter on consumer which is correct.

enter image description here

I need the slicer in the drill-through page to show slicer options for other segments as well and not just consumers. Drill-through should filter the report as intended but I want the slicer to be selected for 'consumer' and still show the other slicer options.

Something like this: enter image description here

Currently it is not possible without actually removing the drill through filter for visualizations pane.

Here is the PBIX file:

Please help.

Dhiraj D
  • 63
  • 8

0 Answers0