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 for quarters. However, i have no idea how to incorporate it in the table.

2)How to make (at least) the text visible? ( prefer to use symbols) The data is based on the inspection results from workorders

 

 

Current progress 😅

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).

     

4 Replies

  • 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).

     

  • v-veshwara-msft's avatar
    v-veshwara-msft
    Community Support
    1 year ago

    Hi Anonymous ,
    Just wanted to check if the solution provided by danextian has met your needs. If yes, Please consider marking it as "Accepted Solution" to assist others with similar queries. If further assistance is needed, please reach out.
    Thank you.

  • v-veshwara-msft's avatar
    v-veshwara-msft
    Community Support
    1 year ago

    Hi Anonymous ,

    Just checking in again as we haven’t heard back from you. If the provided solutions addressed your issue, kindly mark the helpful reply as the Accepted Solution to assist others with similar queries.

    If your issue is still unresolved or you need further help, feel free to reach out.
    Thank you.

  • v-veshwara-msft's avatar
    v-veshwara-msft
    Community Support
    1 year ago

    Hi Anonymous ,

    Following up to see if your query has been resolved. If any of the responses helped, please consider marking the relevant reply as the 'Accepted Solution' to assist others with similar questions.

    If you're still facing issues, feel free to reach out.

    Thank you.