Forum Discussion
data transformation
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.
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