Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
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
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
User | Count |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |