Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Mahi1827
Resolver I
Resolver I

How to create custom matrix structure with dynamic headers from measures

Hi,

 

I am looking for custom matix structure with dynamic headers coming from created measures.

my existing structure look like below.

 

Prodcut service  total %total open Open% Close close%
Phase 5               2     13%      5         100%    0        0%
Phase 4               0      0%       5         100%   0        0%
Phase 3               5      33%     0           0%     3        100%
Phase 2               3      20%    1           50%    1        50%
Phase 1               5      33%     0           0%     0         0%
Total                  15     100%   1           13%    4         26%

 

In the above all column headers are done from measures and iwould like to create new header for goruping 2 columns as one set for example

for measures total and %total  i need to create new header "TOTAL" with merge and style .

for measures Open and %open i need to create new header "Open" with merge and style .

for measures close and %close i need to create new header "Close" with merge and style .

my overall expected output like below

 

 Total Open close 
Service TypesTotal% totalOpen%OpenClose%Close
Phase 1533.33%5100.00%00.00%
Phase 2533.33%5100.00%00.00%
Phase 3020.00%00.00%3100.00%
Phase 4113.33%150.00%150.00%
Phase 500.00%00.00%00.00%
Total15100.00%1173.33%426.67%

 

Please check sample pbix file here :

https://onedrive.live.com/?cid=9E9277B1AE261150&id=9E9277B1AE261150%21118&parId=root&o=OneUp

 

I have tried with diffrent options by dax with select columns but i didnt get expected result as same structure as above . so please share your inputs and posssible solution.

 

Thanks in advane for your help.

 

Thanks,

mahi1827

 

3 REPLIES 3
v-yingjl
Community Support
Community Support

Hi @Mahi1827 ,

Based on your description, although the expected output is clear, not certain whar does your measure look like and the sample file is no longer to download.

Could you please consider re-sharing the sample file for further discussion?

 

Best Regards,
Yingjie Li

Anonymous
Not applicable

Hi @Mahi1827 -

 

I wasn't able to find your sample file at the given location.

You can get help from this post -https://community.powerbi.com/t5/Desktop/Matrix-column-header-label-custom-group/m-p/1253196

 

Appreciate your kudos!! If this post helps, then please consider Accept it as the solution to help the other members find it more.

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.