Matrix - unable to sort by the column and need assistance with calculated column

[talhaparvaiz]

Hi,

we have survey data in the format shown below. I need to create a report to display, for each app,

A) how the users responded to the issues individually and

B) what's the percentage of Total app users are facing the issue

C) what's the percentage of respondents are facing the issue

D) these columns should be sortable

I tried Matrix, but facing the following issues

1) it's not letting me sort by "Yes % (count of Yes / Count of unique User ID)" 

2) not sure how to calculate the following "Yes % (Count of Yes / total App Users)"

Please advise

Thanks

[v-jayw-msft]

Hi @talhaparvaiz ,

It's not supported to sort the matrix by specified column.

You may vote for this idea.

https://ideas.powerbi.com/ideas/idea/?ideaid=05c64cd1-c0d0-44d3-bceb-21f4acc0e548 

Best Regards,

Jay

[rjhartop]

Hi, this blog post may help with (1), sorting by a matrix column:

https://affinityworks.co.uk/power-bi-matrix-column-sort-sorted/

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[talhaparvaiz]

Hi, kindly following up on this request

thanks

[Ashish_Mathur]

Hi,

I do not understand your question at all.  The visual that you have created in your PBI file bears no semblance to the image you shared in your original post.

[talhaparvaiz]

Where can I upload the file... it's a small sample file, can I email it to you?

[Ashish_Mathur]

Hi,

Upload it to Google Drive and share the download link here.

[talhaparvaiz]

https://drive.google.com/file/d/1-xq_y63djhMOpmtRgtoD1UN_4mhI0D9S/view?usp=sharing

Here is the file

Thanks