Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello All,
If I have the following table in Power BI which I am using as my data source (say in an Excel format) with the following structure as per below.
| Name | Basketball | Tennis | Hockey |
| John | 3 | 3 | 2 |
| Chris | 3 | 3 | 3 |
| Pedro | 5 | 5 | 4 |
I have done numerous visualisations, various measures and calculalted columns then I decided I need another column to the table (Gender);
1. Can you add another column after initial data source attchment?
2. How is this done?
Gender | Name | Basketball | Tennis | Hockey |
Male | John | 3 | 3 | 2 |
Female | Chris | 3 | 3 | 3 |
Male | Pedro | 5 | 5 | 4 |
Solved! Go to Solution.
Gary,
Actually it was as easy as that. For some reason I thought that it would not work.
Thanks
User | Count |
---|---|
131 | |
74 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |