Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Community,
Is it possible to create something like a dictionary in Power BI? For example, if you enter the value ‘Velo’ somewhere, could it show the exact table or tables where this value could be found? In this case, the financials table.
Does anyone have any tips or tricks to share? Much appreciated.
Solved! Go to Solution.
Thanks for the reply from @Tahreem24 , please allow me to provide another insight:
Hi @Julia2023 ,
I created some data:
Table1:
Table2:
Here are the steps you can follow:
1. Create calculated column.
Create a calculated column for each table to represent the name of the current table.
NAME = "Table1"
2. Click Q&A visual.
3. When you enter a Value, it will automatically display which table it is in, and when you click on a table, it will display the information of that row only.
4. If you want to display the searched values in more than one table, you can create a search summary table containing all the searched information.
Create calculated table
search_table =
UNION(
'Table1','Table2')
5. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks for the reply from @Tahreem24 , please allow me to provide another insight:
Hi @Julia2023 ,
I created some data:
Table1:
Table2:
Here are the steps you can follow:
1. Create calculated column.
Create a calculated column for each table to represent the name of the current table.
NAME = "Table1"
2. Click Q&A visual.
3. When you enter a Value, it will automatically display which table it is in, and when you click on a table, it will display the information of that row only.
4. If you want to display the searched values in more than one table, you can create a search summary table containing all the searched information.
Create calculated table
search_table =
UNION(
'Table1','Table2')
5. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@Julia2023 As of now, I don't think sp its possible.
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
66 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |