Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good Morning,
I'm currently trying to combine 2 columns with the same drop down options (so same text datasets) so I can use a visualization to see the total amount of times each categories were used. Each line is linked to the accounts those categories were featured at.
So I want to be able to see 1 visualization with the accounts down 1 axis and the categories on the other axis.
Thanks!
Solved! Go to Solution.
HI @rchiang,
Maybe you can try to use unpivot table feature to convert these columns to key and value columns, then remove duplicate records. After these steps, you will get merge records.
Regards,
Xiaoxin Sheng
HI @rchiang,
You can try to use below formula to get merged unique list:
NewTable = DISTINCT ( UNION ( VALUES ( 'Table'[Product1] ), VALUES ( 'Table'[Product2] ) ) )
Regards,
Xiaoxin Sheng
Hi @v-shex-msftXiaoxin,
Thank you for your help for that.
I should have showed the actual table I want combined
I want to have 1 column that will show the account with category .
So it would be
Column 1 / Column 2
PCM US / Docks and Hubs
PCM US / Racks and Enclosures
Thanks again!
Would that be possible?
HI @rchiang,
Maybe you can try to use unpivot table feature to convert these columns to key and value columns, then remove duplicate records. After these steps, you will get merge records.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |