Forum Discussion

jaspijk's avatar
jaspijk
Helper I
6 years ago

2 tables, relationsship and visual

Hi,

 

I've two tables: 'Employee Consult pivot' and 'Scanvragen MC'

 

I want tot make a visual (see image)with the questions (vraagtekst)form 'Scanvragen MC' and the avarage form the other tabel 'Employee Consult pivot'. How can I do that?

 

Jacques

Need Help
Show and Tell

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi jaspijk，

     

    First create a relationship between the 2 tables;

    Then create a clustered bar chart to realize what you need:

     

    For the related .pbix file,pls click here.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
    • jaspijk's avatar
      jaspijk
      Helper I
      6 years ago
       
       

      Hi, v-kellya-msft 

       

      Thank You very much. A ew questions. My first table Employee Consult pivot is a table that I transponded to get the keys for the raltionschip in the first colomn. So now I have the key in the forst column and the values in the other columns. To get het value for the visual I have tot sumerize the rows in the table. Bu they are varieng when the table gets upaded form the database. How can I summerize the rows in a single value per row. In Your example I get servaral values in 1 row per city. Thank You.

       

      Jacques

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi  jaspijk ,

         

        The values will be aggregated automatically if they have the same Axis value.

         

         
        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!