Forum Discussion
Merging two rows into one and using new rows in a graph
I am trying to combine rows "." and ".." into one. I would like to add up their sale numbers as well and rename the new column to "EquipmentSales" instead of the dots. I have about 4 tables like this I am trying to merge the two rows. Once I have this, is there a way to take the new columns from each table and put them in a graph?
Any tips or recommendations are helpful! Thank you so much.
3 Replies
- amitchandak
Super User
Anonymous , You should sales table where you can have an additional column where you have . and .. as . and rest all are same.
or use segmentation or binning
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualizationamitchandak Thank you!
I tried grouping them for some reason the "group" is not an option. Any ideas?
Anything is helpful. Thank you!
v-yingjlCommunity Support
Hi Anonymous ,
To use grouping, select two or more elements on a visual by using Ctrl+click to select multiple elements. Then right-click one of the multiple selection elements and choose Group from the context menu.
Please refer this document about grouping in power bi desktop: Use grouping and binning in Power BI Desktop
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
