Forum Discussion

rebam12's avatar
rebam12
Helper I
1 year ago

data transformation

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  ...
Need Help
Show and Tell
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Community Champion
1 year ago

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's avatar
    rebam12
    Helper I
    1 year ago

    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