Need to create Quarter wise sales matrix with previous and selected year basis.

[Anonymous]

Hi All,

I would like to create matrix table quarterly for previous year and selected year with dynamic column change based on selection.
Similar to below table.

Thanks in advance

Slicer
Year		Previous Year -2014	Selected Year -2015
2015		Q1	Q2	Q3	Q4	Total	Q1	Q2	Q3	Q4	Total

[v-karpurapud]

Hi @Anonymous 

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[v-karpurapud]

Hi @Anonymous 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-karpurapud · Accepted solution]

Hi @Anonymous  

Welcome to the Microsoft Fabric Forum,
 

Regarding the creation of a Quarter wise sales matrix with previous and selected year basis.

While I may not have full visibility into the specific structure of your dataset, I have created a sample .pbix file to demonstrate one possible approach to implementing the desired logic.

 I’ve included relevant screenshot and attached the .pbix file for your reference.Please take a moment to review them and see if this solution aligns with your requirements.

If this doesn’t fully meet your needs, could you kindly share a sample of your data and more detailed context? That would help us provide a more accurate solution.

If this response resolves your query, kindly mark it as Accepted Solution to help other community members. A Kudos is also appreciated if you found the response helpful.

Thank You!

[Anonymous]

Thanks for reply,

It is not satisfy the my requirement. I was looking in the different format . This will work if you want to se yearly. But I am looking Year and quarter.

[v-karpurapud]

Hi @Anonymous 

Could you please confirm if your query have been resolved the solution provided by @danextian ? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.

Thank you

[danextian]

Hi @Anonymous 

While this is possible, this isn't possible out of the box and can require a significant amount of development time. The approach involves using a disconnected table that contains all possible column combinations and their hierarchy as well as how they will be sorted and also a measure or measures referencing these columns.  Attached are sample pbix files which might be relatively simpler than what you're trying to achieve. These aside, there are premium custom visuals that can possibly do this albeit at a very high premium.