Power bi: using value from one table as group by in table visual

[WilliamA]

Hi all, 

Looking for a way to achieve this requirement. 

Table A is a config table with 2 columns, key and value. Eg

Card1, issue

Table B is the main dim table that has numerous columns. 

How can I create a table visual ( or any visual) that groups table B By the value from table A where key = card1 

In this scenario the table visual should return the values of the issue column from table B.

If table A gets updated to "Action" then the table visual should now group by the action column from table B.

Thanks,

[v-binbinyu-msft]

Hi @WilliamA ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu

[Igna]

Hi,

You could try to use a measure in the visual with something like that :

SelectedValue = 
VAR SelectedKey = SELECTEDVALUE('Table A'[key])
RETURN
    SWITCH (
        SelectedKey,
        "Card1", SELECTEDVALUE('Table B'[Card1]),
        "Action", SELECTEDVALUE('Table B'[Action]),
        // Add more cases as needed
        BLANK()
    )

Hope it helps.

Igna