2 tables, relationsship and visual

[jaspijk]

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

[Anonymous]

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]

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]

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!