Forum Discussion

Julia2023's avatar
Julia2023
Helper I
2 years ago
Solved

Power BI Dictionary

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.

 

 

Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

     

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

     

    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