data transformation

[rebam12]

I have this type of question .. now i dont know how i map the data and create the graph.. 

Source

Values 1-6 

1	Not familiar
2	Do not trust at all
3	Slightly trust
4	Moderately trust
5	Mostly trust
	Completely trust

Q2s1  Search engine *e.g google

Q2s2  GenAI answer engine *CHATGPT

Q3s3  Offical Prduct

and data is 

Now how should i map the data ..i try to unpivot the data but no results.

ID	Q2s1	Q2s2	Q2s3
1	1	2	3
2	2	2	1
3	3	1	2
4	3	3	2
5	3	1	1
6	2	3	3

[audreygerred]

Hi! You would def want to unpivot in Power Query so that your data looks like below:

Then, in Power BI desktop you would join this table to the value field in the unpivot

And, you would join this table to the attribute field

[rebam12]

@audreygerred u mean i have to create 2 tables for join ?

[audreygerred]

These are the three tables you would have:

1.

2.

3. 

[elitesmitpatel]

give us the dummy data and and output u want according to the dummy data

[rebam12]

i already the paste the data.. and output i dont know .. this is waht i want.. how i create graphs from these tables

[Greg_Deckler]

@rebam12 If you unpivot the data in the 2nd table then you should be able to form a relationship between your first and seconnd table and display the text using RELATED. If you leave them unrelated you can use LOOKUPVALUE or MAXX( FILTER( .. ), ... ) to lookup the text value. Not sure what your ultimate end goal is though:

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[rebam12]

THANKS

i tried many time to identify how should i vizuale the data but did not get any clue..

like if i drag ID on x axis AND values on y axis.. then how i cateogries the Q2s1...Q2s3 in one graph   and first how i transform the data