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