data transformation

Question

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 · Answer

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

&nbsp;
&nbsp;

greg_deckler · Answer

rebam12&nbsp;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:
&nbsp;
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/1116882Also, 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/38490The most important parts are:1. Sample data as text, use the table tool in the editing bar2. Expected output from sample data3. Explanation in words of how to get from 1. to 2.

rebam12 · Answer

THANKS&nbsp;i tried many time to identify how should i vizuale the data but did not get any clue..&nbsp;like if i drag ID on x axis AND values on y axis.. then how i cateogries the Q2s1...Q2s3 in one graph&nbsp; &nbsp;and first how i transform the data&nbsp;