Matrix Report - Multiple columns

[mrafiqahmed]

Hi,

I'm developing a matrix report in which I have added 2 fields 'weekname' and 'probability' under columns. I expect it would group by 'weekname' first followed by group by 'probability'. But, it groups by 'weekname' only and ignores 'probability'.

What I would like to see is like this

                  1st Week                    |                  2nd Week

10      20      40      60      80         | 10      20      40      60      80

How can I achieve this?

TIA

Rafiq

[amitchandak]

@mrafiqahmed , if these are relative weeks then you need to do senmentation.

SEGMENTATION

https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-po...
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

If these are year week, refer

https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...

https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...

[Anonymous]

Hey @mrafiqahmed,

Try 3 different solutions:

1. Use Matrix table and then drop your fields at the columns field:  Week name -> Probability

2. Try to create hierarchy: Week name -> Probability(if possible)

3. you can try the custom visual: Acterys Matrix Light

another solution that I found in the web:

https://wessexbi.wordpress.com/2014/02/27/unpivot-nested-headings-with-power-query/

Ariel

[mrafiqahmed]

Thanks @Anonymous . Acterys Matrix looks good. But, it doesn't support conditional formatting? I want to change the text color based on some condition.

Thanks

Rafiq

[dax]

Hi @mrafiqahmed , 

I am not clear about your requirement of conditional formatting,  if possible, could you please inform me your expected output and sample data? By the way, you could refer to desktop-conditional-table-formatting  for details.

Please do mask sensitive data before uploading.

Best Regards,
Zoe Zhi

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