Forum Discussion
Custom Adding Columns in a Matrix
A. Current Matrix "Sales of Food by Day of Week "
- Rows: Food dimension
- Columns: Date dimension
- Values: [Sales] measure
B. Wanted Result
- Same Rows and [Sales] measure .
- I can turn on the "Total" column by using Subtotal or Grand Total matrix settings.
- Question: I want to add extra "custom" subtotal columns ("Weekdays" and "Weekend" columns in blue background). What should I do to achive custom adding columns in a matrix?
By creating a 2nd day type, weekend/weekday, you can put both into the column part of the matrix and get this result. Will that work?
My fields are as follows:
See my PBIX file on how I did this. There is a full date table here and I added the Day Type column. If the day is SatSun, then Weekend, else Weekday.
NOTE: I just did this with the June 2021 Power BI desktop, so if you get an error when opening try and click through it, or upgrade.
3 Replies
By creating a 2nd day type, weekend/weekday, you can put both into the column part of the matrix and get this result. Will that work?
My fields are as follows:
See my PBIX file on how I did this. There is a full date table here and I added the Day Type column. If the day is SatSun, then Weekend, else Weekday.
NOTE: I just did this with the June 2021 Power BI desktop, so if you get an error when opening try and click through it, or upgrade.Thanks edhans for your short workaround, it gives the expected sub-total columns.
Great! Glad I was able to help mybarbie9917
