How to Make Custom Sort of Value from Many Column/Many Parameters on different chart?

[Anonymous]

Hi all, 

I have a set of Data with 9 Column, each column has value of:

a. Very Not Confident
b. Not Confident
c. Confident
d. Very Confident

This is the example of the table:

No	A	B	C	D	E	F	G	H	I
1	Very Confident	Confident	Confident	Confident	Confident	Confident	Confident	Confident	Confident
2	Confident	Confident	Confident	Confident	Confident	Confident	Confident	Confident	Confident
3	Not Confident	Not Confident	Not Confident	Not Confident	Not Confident	Not Confident	Not Confident	Not Confident	Not Confident
4	Confident	Not Confident	Confident	Not Confident	Confident	Not Confident	Confident	Confident	Confident
5	Very Confident	Very Confident	Very Confident	Very Confident	Very Confident	Very Confident	Very Confident	Very Confident	Very Confident
6	Not Confident	Confident	Confident	Not Confident	Not Confident	Confident	Not Confident	Not Confident	Not Confident
7	Not Confident	Confident	Confident	Confident	Not Confident	Very Confident	Not Confident	Not Confident	Not Confident
8	Very Not Confident	Confident	Not Confident	Very Not Confident	Very Not Confident	Very Not Confident	Confident	Very Not Confident	Very Not Confident
9	Very Not Confident	Very Not Confident	Confident	Very Not Confident	Confident	Very Confident	Confident	Not Confident	Very Not Confident
10	Not Confident	Confident	Confident	Not Confident	Not Confident	Confident	Not Confident	Not Confident	Confident
11	Confident	Confident	Very Confident	Confident	Confident	Confident	Confident	Confident	Confident
12	Not Confident	Not Confident	Confident	Not Confident	Confident	Not Confident	Not Confident	Not Confident	Not Confident
13	Not Confident	Not Confident	Confident	Not Confident	Confident	Not Confident	Confident	Confident	Not Confident
14	Not Confident	Confident	Confident	Confident	Confident	Confident	Confident	Confident	Confident

I want to Visualize on PowerBI Chart. If i import the data in powerBI i will have the table:

 I need to make Chart from each parameter/Column:

I would like to custom the sorting to be:

a. Very Not Confident
b. Not Confident
c. Confident
d. Very Confident

It is possible to have the custom also applied on Chart forB, C, D, E, F,G,H,I?

Thank you.

[selimovd]

Hey @Anonymous ,

yes, you can do that with a sort by column:

Sort By Month Names In Power BI (c-sharpcorner.com)

But you have to have an own sort by column for each column (A to I).

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[Anonymous]

Hi @selimovd, 

So i have to make the sort number column for each column i want to sort? From A to I? 

So i will have 
A A-sort number B B-sort number ... I I-sort number

Thank you

[selimovd · Accepted solution]

Hello @Anonymous ,

unfortunately yes.

You can also add calculated columns and mark them as sort by column with Tabular Editor, this might be a little faster than with the Power BI editor.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi