Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi Folks, needs some advice. I have a table that look something like below
Customer Name | Label 1 | Label 2 | Label 3 | Label 4 | Label 5 |
Customer A | Microsoft | "blank" | Customer A | Team A | Cloud |
Customer B | Team A | Redhat | On Premise | Customer B | "blank" |
Customer C | Apple | Customer C | Team C | "blank" | On Premise |
Customer D | On Premise | Team B | "blank" | Customer D | SUSE |
Intention is that I want to be able to use slicer to filter out information and present the corrosponding data. Example
1. Which team has been servicing which customer
2. What customer has been using which product
Can anyone guide me in getting this done?
Have tried looking at https://www.youtube.com/watch?v=UvvS376vYSw but my data are all strewn in 8 different columns (label 1 - label 😎 and hence it doesn't work for me.
Solved! Go to Solution.
Hi @woojacky ,
Best option appears to me is to unpivot this data and then try to identify on each line what is the type of data you are using and then pivot based on that new column. Do you have any list of the Teams and of the products?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks for providing some guidance there. Had to read up exactly how does one unpivot in the first place. So just for reference for others who might encounter similar issue, below are broad steps that I've done.
1. Create an INDEX in my main table (this is to be used for table relationship at the end)
2. Create a new table
3. Duplicate the necessary columns that I need to unpivot (in my case are label, label1, label2, label3, etc), I used REMOVED OTHER COLUMNS
4. Make sure INDEX is also duplicated into this new table
5. Then choose UNPIVOT OTHER COLUMNS based on INDEX
6. Select Many to One relationship with INDEX as the unique value as reference
Tada.
Hi @woojacky ,
Sorry but I lost your previous message on the notifications I got and did not answer you. But glad you were abble to figure it out.
Just an adittional hint instead of duplicate you can use the reference also.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @woojacky ,
Best option appears to me is to unpivot this data and then try to identify on each line what is the type of data you are using and then pivot based on that new column. Do you have any list of the Teams and of the products?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsYes I have a list of teams and products. How do I unpivot as the data is in my original CSV file? I was thinking of using extract if "text" but might be too much of a hassle though
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
81 | |
67 | |
61 | |
46 | |
45 |