Forum Discussion

WilliamA's avatar
WilliamA
Icon for Helper I rankHelper I
3 years ago

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

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,

Need Help
Tips and Tricks

2 Replies

  • Igna's avatar
    Igna
    Icon for Resolver III rankResolver III
    3 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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