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

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
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

ShaunBizSol's avatar
ShaunBizSol
Frequent Visitor
9 years ago

You are a life savor. I have applied this to our actual data set, added a few additional columns and its working perfectly.

 

Thank you very much for your help

Shaun