Forum Discussion
Add Measure in Matrix, but it should not repeat on all columns
In Power BI Matrix visualization, I have a Amount sold by year and Target amount by Date.
I can easily do the Pivot in Matrix and get the result for Amount sold and Target by Year and Months.
BUT the problem is,
I just want to add one more Measure to that will calculate the Average sold, and I don't want to repeat that Meausre for each months, It should be just at last colum with Total Amount , Total Year , Average.
Let me know how we can get this.
v-chuncz-msft, I have provided the feedback on the link that you provided,
We can close this issue for now, considering this is a limitation for now.
6 Replies
v-chuncz-msftCommunity Support
v-chuncz-msft : No this is not the solution, I want 2 columns added, one for sum and other for measure.
2018 Name Jan Feb March April Sum Avg Name1 10 20 30 10 70 17.5 Name2 20 30 40 10 100 25 Name3 30 10 10 10 60 15 Name4 40 20 20 20 100 25 Name5 50 30 30 30 140 35 I want to have the Avg Column as well aside to Sum, I have created the measure in report, but I am not able to achive the result wiht Matrix visualization.
- v-chuncz-msft
Anonymous,
Currently, there is no elegant way. You may adjust the column width manually to hide them.