Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have an Excel-dataset which looks like this:
4 Food | 260 |
41 Fruits | 170 |
411 Apple | 100 |
412 Banana | 70 |
42 Vegetables | 90 |
421 Lettuce | 50 |
422 Tomatoes | 40 |
5 Medicine |
Can PowerBI recognize the sum rows while importing the data? Is there an opportunity to mark rows as sum of the others? Or should the data be cleaned before importing to PowerBI?
Thanks for your help in advance.
Regards
Jenny
Solved! Go to Solution.
Hi @Anonymous ,
Power BI won't recognize the total rows automatically while importing the dataset. You may need to transform data. Please have a look at below workaround.
Split the Category ID column.
Result table.
Use a Matrix to display data. Turn off "Stepped layout" option.
Best regards,
Yuliana Gu
Hi @Anonymous ,
There are two columns in source dataset, right? What does each column refer to?
Can PowerBI recognize the sum rows while importing the data? Is there an opportunity to mark rows as sum of the others?
What do you mean "sum rows"? What is your desired output in Power BI?
Best regards,
Yuliana Gu
Hi Yuliana,
e.g. the category fruits is the sum of banana & apple as well as the category food is the sum of fruits and vegetables. My question is how PowerBI can recognize these rows as totals of the other while importing the dataset. Or if there is an opportunity to mark those rows as totals afterwards.
Thanks
Jenny
Hi @Anonymous ,
Power BI won't recognize the total rows automatically while importing the dataset. You may need to transform data. Please have a look at below workaround.
Split the Category ID column.
Result table.
Use a Matrix to display data. Turn off "Stepped layout" option.
Best regards,
Yuliana Gu
Oh okay, too bad that this is not possible. But thank you for your help and solution! 🙂
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |