When drilling down on a visual, can you control other visuals drill down level too?

I don’t think this is possible natively. However, you can perhaps get similar or equivalent behavior leveraging Slicers, Parameters and Calculated Fields.

Step 1: Create a Slicer (with parameter attached to it) with hardcoded values like “Year”, “Quarter”, “Month”, “Day” to allow you to choose the granularity of the Visuals.
Step 2: Create a calculated field based on the parameter created in the previous step
Step 3: Project that Calculated filed as the Dimension.

Please see the snapshot below for your reference. Hope this helps. In case, this solves your query, please mark this post as Solution. Cheers!!

1 Like