TABLE VISUAL - NOT SHOWING CORRECT VALUE

[Cholo]

Hello Everyone,

I'm a newbiew working on a  BI report, I want to show/display the header (Questions) as rows. Then categorize it now by 2 columns which is Manufacturer Rate & Supplier Rate. The concern is I use a filter to sort/display the result below by using the respondent category and supplier name. If this question was raise before and resolved please help me redirect to that same question. Appriciate any support provided. 

Sample I will use the following filter;

Respondent = Manufacturer, Supplier = ABC Enterprise.

The expected output should be like, on

Question       |   Manufacturer Rate | Supplier Rate

PPM's L12M  |             6                   |          7

Data Source Below:

Respondent Category	PPMs L12M:	PPMs L12M Remarks:	PPMs L3M:	PPMs L3M Remarks:	Sub-Tier Supplier Management:	Sub-Tier Supplier Management Remarks:
Manufacturer	6	TEST ONLY	9	TEST ONLY	1	TEST ONLY
Supplier	7	TEST ONLY	7	TEST ONLY	2	TEST ONLY
EXPECTED OUPUT:
Questions:	Manufacturer Rate	Supplier Rate
PPMs L12M	6	7
PPMs L3M	9	7
Sub Tier	7	2

[lbendlin · Accepted solution]

Your data source is in a bad shape and needs to be unpivoted to make it usable.

Then you can load it into Power BI and use a matrix visual

[Cholo]

Hello @lbendlin,

I really appriciate your support on my concern above. I was able to show now the data I need 😊

Just one more concern what if, I want to show each question range value, how I can show the columns also?

Since on the actual report the respondent category should be drag on columns. I was thinking if should I just create a new table with range per each question and lookup it? But its seems like not working on a matrix table. Do you have any thoughts on this? 

EXPECTEDOUPUT:
Questions:	Range	Manufacturer Rate	Supplier Rate
PPMs L12M	0 - 10	6	7
PPMs L3M	0 - 10	9	7
Sub Tier	0 - 10	7	2

When I tried to drag the RANGE column into ROWS from new table I created with values, which I just use the questions as their relationship since each questions are unique. This was the actual report looks like, the range values are under its question which I want to be as columns too if possible. 

[lbendlin]

Use a fake aggregation like MAX, MIN, or AVERAGE when you add that column to the values area of the matrix.

[Cholo]

Great! This works, appriciate your support on this @lbendlin  😊