Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Need help with Matrix Table

Hi all, I am a new Power BI user. Currently i am trying to replicate the table as in the picture below. 1) How to segregate the year into quarters? (I already create a new column in the data source...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi Anonymous 

     

    Quarter values must also exist in your semantic model. You can create one using DAX or M. Ideally, you must  use a separate dimensions table. Add both Year and Quarter columns to the matrix visual and expand the column until Quarters are visible.

    Please see the attached sample pbix.

     

    Below is a sample custom column formula for quarter of the year (case-sensitive).

     

danextian's avatar
danextian
Super User
1 year ago

Hi Anonymous 

 

Quarter values must also exist in your semantic model. You can create one using DAX or M. Ideally, you must  use a separate dimensions table. Add both Year and Quarter columns to the matrix visual and expand the column until Quarters are visible.

Please see the attached sample pbix.

 

Below is a sample custom column formula for quarter of the year (case-sensitive).