Forum Discussion
Hybrid Matrix Adding Rept Column at Right Column After Total column Matrix
Hi Everyone,
I'm trying to create a rept column after Total Column in a Matrix table Power BI. I'm hoping the end would be like this (I'm creating it in Ms. Excel)
and this one is halfway complete in PowerBI
Here's the link to the pbix file
and here's the excel file
sorry, I didn't find any features to attach files here.
Thank you for the help
Warm regards
Adrian
Hi Paiman89
We don't have this functionality in Power BI.
You can suggest it as the idea here:
https://ideas.fabric.microsoft.com/ideas
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
Hi, Paiman89
You can try the following to replace the Total column with a rept chart.
Measure = IF(HASONEVALUE(Table1[MonthShort]),SUM(Table1[Sell Out (pcs)]),[TotalPcs])Please see the attached document.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Paiman89
We don't have this functionality in Power BI.
You can suggest it as the idea here:
https://ideas.fabric.microsoft.com/ideas
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
Hi, Paiman89
You can try the following to replace the Total column with a rept chart.
Measure = IF(HASONEVALUE(Table1[MonthShort]),SUM(Table1[Sell Out (pcs)]),[TotalPcs])Please see the attached document.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.