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 th...
Need Help
Show and Tell
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!