Forum Discussion
Sum rows in dataset
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! :)