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