topic Re: Hi All, I want to group 5 columns and display q1,q2,q3,q4 Like below image in DAX Commands and Tips

Hi All, I want to group 5 columns and display q1,q2,q3,q4 Like below image

rupa1006 — Thu, 04 Jan 2024 15:48:17 GMT

Hi All, I want to group 5 columns and display q1,q2,q3,q4 Like below image.

I have created the hierarchy for all the 5 columns but not getting proper results.

Re: Hi All, I want to group 5 columns and display q1,q2,q3,q4 Like below image

rupa1006 — Thu, 04 Jan 2024 01:13:41 GMT

Fowmy 123abc Jihwan_Kim Dangar332 If you guys have any idea please respond.Thank you.

Re: Hi All, I want to group 5 columns and display q1,q2,q3,q4 Like below image

Anonymous — Thu, 04 Jan 2024 07:16:04 GMT

Hi rupa1006 ,If I understand correctly, the issue is that you want to group 5 columns and display q1, q2, q3, q4. In order to make a deep troubleshooting, could you please provide more raw data(exclude sensitive data) with Text format or screenshot? It would be helpful to find out the solution.

You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

Looking forward to your reply.

Best Regards,

Wisdom Wu

Re: Hi All, I want to group 5 columns and display q1,q2,q3,q4 Like below image

rupa1006 — Thu, 04 Jan 2024 12:51:39 GMT

Hi Anonymous , Thank you for response- When I drill down i want grouping by admin uni, then subdivided by quarters -Like Q1- Group Admin unit 1,Admin unit 2,Admin unit 3,Admin unit 4,Admin unit 5 and Q2 - Group Admin unit 1,Admin unit 2,Admin unit 3,Admin unit 4,Admin unit 5 and Q3 - Group Admin unit 1,Admin unit 2,Admin unit 3,Admin unit 4,Admin unit 5

I will share the screen shots

Re: Hi All, I want to group 5 columns and display q1,q2,q3,q4 Like below image

Anonymous — Mon, 08 Jan 2024 08:54:18 GMT

Could you please provide more raw data(exclude sensitive data) with Text format or screenshot?

You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum