Forum Discussion

mybarbie9917's avatar
mybarbie9917
Frequent Visitor
5 years ago
Solved

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 . - ...
Show and Tell
Tips and Tricks
Tutorial Requests
  • edhans's avatar
    edhans
    5 years ago

    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.

edhans's avatar
edhans
Community Champion
5 years ago

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.

  • mybarbie9917's avatar
    mybarbie9917
    Frequent Visitor
    5 years ago

    Thanks edhans for your short workaround, it gives the expected sub-total columns. 

    • edhans's avatar
      edhans
      Community Champion
      5 years ago

      Great! Glad I was able to help mybarbie9917