Power BI Survey

[Anonymous]

Hi Everyone

I build a report on Forms, and I'd like to use these values to make a dashboard on BI

So I've 12 evaluations points  that I group in 3 big famillies

So I'd like to be able to join build this 3 famillies, with hierarchies but I can't

For example, I have to evaluate a course, so I want the average value for this course and when I click on it, I'd like to vizualise the value for the points which are in this familly, is it possible?

I'd like to calculate the average for each point, and after group this average for the point which is concern with some people (I add a tick box to select the person I want) The problem, I can't add spaces in my chart so I've a chart with 24 bars so It's unreadable, any idea?

Many thanks in advance for your help