Quarterly Data Trend by Category by Region

[Bala_Robin]

Hello,

I'm new to PowerBI and need suggestions (Pls don't just give one word answer like DAX query but rather would need guidance) on how to display by subscription (Bronze, Silver, Gold) by Quarter by Zone

Dataset:

Zone	User	Q1	Q2	Q3
East	User1	Silver	Silver	Gold
East	User2	Bronze	Silver	Gold
East	User3	Silver	Gold	Gold
West	User4	Bronze	Bronze	Gold
West	User5	Silver	Bronze	Gold
North	User6	Gold	Silver	Bronze

Dashboard (Desired) (Note: Subscription : Bronze, Silver and Gold will be merged cell)

Subscription	Bronze	Bronze	Bronze	Silver	Silver	Silver	Gold	Gold	Gold
Zone	Q1	Q2	Q3	Q1	Q2	Q3	Q1	Q2	Q3
East	1			2	2			1	3
West	1	2		1					2
North			1		1		1

Looking forward for the quick help from the community.

Thanks

[Bala_Robin]

Also how to display in % by quarter

[vicky_]

Right-click on the count (or whatever your measure is), and then go to Show value as and select the option % of row total

[Bala_Robin]

the requirement is by quarter and row total would be incorrect for this

[Bala_Robin]

Thanks so much @vicky_ for the quick and the detailed response

[vicky_ · Accepted solution]

There is a way of doing this easily without dax that requires you to change the data structure. Go back into Power Query, and select the Q1, Q2 and Q3 columns. Then unpivot. 

You should get a table like the below:

Then you can basically just use the following setup to get your desired result.