Need help with Matrix Table

[Anonymous]

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 😅

[v-veshwara-msft]

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.

[v-veshwara-msft]

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]

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.

[danextian · Accepted solution]

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