Forum Discussion

ShaunBizSol's avatar
ShaunBizSol
Frequent Visitor
9 years ago
Solved

Same data in two columns. Need to visualise values within a table referencing the same name.

Hi all,   Novice here. With an issue in how to show data in a certain way.   Effectively, we are attempting to visualise two or three columns, that have a number within relating to a specific nam...
Need Help
Tips and Tricks
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi ShaunBizSol,

     

    You can also use DAX like below. You can check attached .pbix file.

     

    Table = UNION(SELECTCOLUMNS('Table1',"Name1",'Table1'[Name1],"Value1",'Table1'[Name1 Number]),SELECTCOLUMNS('Table1',"Name2",'Table1'[Name2],"Value1",'Table1'[Name2 Number]))

     

    Best Regards,
    Qiuyun Yu

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

I think what you need to do is to create 3 queries. The first query imports Name1 and Name 1 Number only and I would add an Index. The second query imports Name 2 and Name 2 Number only and also add an Index. Then create an append query to append them together.