Drill down without a strict hierarchy

[sagmukhe]

If I understand correctly then you are basically looking to see the data at a particular granularity (not fixed) based on user’s choice or desire. That kind of flexibility can be attained using parameter. There’s a similar post which can give you some idea on that. Please take a look at it.

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 bel…