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