Replicating Qlik Sense behavior: Dynamic grouping by QCI or Reportees from different tables

The standard Power BI approach for this is Field Parameters, which were designed exactly for this kind of dynamic dimension switching.
Setup:

Go to Modeling → New parameter → Fields
Add both your QCI column and your Reportees column to the parameter
This creates a disconnected table with a slicer — selecting "QCI" or "Reportees" changes which field is active

Use in the matrix:
Put the Field Parameter in the Rows well of your matrix instead of a fixed column. The matrix rows will then switch between QCI and Reportees based on what the user selects in the slicer.
For the revenue measure, you may need a measure that's aware of which grouping is active:
daxRevenue by Selection =
IF(
SELECTEDVALUE(GroupingParameter[GroupingParameter Order]) = 0,
[Revenue by QCI],
[Revenue by Reportees]
)
The main limitation vs. Qlik: since QCI and Reportees come from different tables, make sure both have a path to your revenue fact table through the model relationships. If they do, the field parameter approach should give you the same single-slicer dynamic grouping behavior you had in Qlik

Hi Harini07,

Thank you Juan-Power-bi, cengizhanarslan, for your insights.

In Power BI Desktop, use Field Parameters to include both QCI and Reportees in a single parameter. Add this parameter to the Matrix Rows and use its slicer to switch between them, allowing the grouping to change dynamically. Ensure both fields are properly related to the revenue table for correct filtering.

Use report readers to change visuals - Power BI | Microsoft Learn

Implement Data Translation Using Field Parameters - Power BI | Microsoft Learn

Thank you.