https://community.fabric.microsoft.com/t5/Report-Server/PowerBI-Report-Builder-concatanate-multirow-text-in-chart/m-p/3341048#M30601 <P>Hello,&nbsp;</P><P>&nbsp;</P><P>I have the bellow dataset, and i want to display it in a chart sort by "Dept" in row and "Level" in column but i want a specific column by "Dept" with my causes of all levels.</P><P><img /></P><P>Currently i succeed to sort by "Dept" and "Level" but my "Causes" column only show the level 2 causes.&nbsp; &nbsp;</P><P><img /></P><P>&nbsp;</P><P>Did you now a way to aggregate the row of my dataset to display it in my chart ?&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 20 Jul 2023 13:52:00 GMT RSI 2023-07-20T13:52:00Z https://community.fabric.microsoft.com/t5/Report-Server/PowerBI-Report-Builder-concatanate-multirow-text-in-chart/m-p/3341048#M30601 <P>Hello,&nbsp;</P><P>&nbsp;</P><P>I have the bellow dataset, and i want to display it in a chart sort by "Dept" in row and "Level" in column but i want a specific column by "Dept" with my causes of all levels.</P><P><img /></P><P>Currently i succeed to sort by "Dept" and "Level" but my "Causes" column only show the level 2 causes.&nbsp; &nbsp;</P><P><img /></P><P>&nbsp;</P><P>Did you now a way to aggregate the row of my dataset to display it in my chart ?&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 20 Jul 2023 13:52:00 GMT https://community.fabric.microsoft.com/t5/Report-Server/PowerBI-Report-Builder-concatanate-multirow-text-in-chart/m-p/3341048#M30601 RSI 2023-07-20T13:52:00Z