Power BI Help

[Carl Lidstone]

Hi All, I am trying to help a staff member who is using Power BI with data they have collect from a Form.  Within the Form they have a ranking question and can see the how each option is ranked.  When they use Power BI, it just does a count so each option is 100%.  Can anyone give me some advice that I can share to change this?  I have put some screen shots below.

Carl

[Mark Baldwin]

Hi Carl

This may be an issue of how the data is set up or it may be an issue of how you have put the data into each field.

In this case I would probably use a set of explicit measures - see my presentation from session 4 of the data conference where I did this with N A M and E grades

 Making a report in Power BI.pdf

Cheers

Mark

On Sat, 17 Apr 2021 at 18:34, Carl Lidstone <lid...@gmail.com> wrote:

Hi All, I am trying to help a staff member who is using Power BI with data they have collect from a Form.  Within the Form they have a ranking question and can see the how each option is ranked.  When they use Power BI, it just does a count so each option is 100%.  Can anyone give me some advice that I can share to change this?  I have put some screen shots below.

Carl

--
You received this message because you are subscribed to the Google Groups "NZ Data Champions" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nz-data-champi...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/nz-data-champions/be28795c-b7d8-4fcd-82ee-336213c37bc9n%40googlegroups.com.