Forum Discussion

Docaste's avatar
Docaste
Regular Visitor
1 year ago

Help with Matrix - Group is greyed out

Hello Power BI Community,

I am looking to create this output in a Power BI matrix but I am having trouble. 

When I place Post_date ('yyyyMM' - 202401, 202302, etc)  into the Column field, it does not group by YearMonth. Instead, it separates the data and calculates each measure independently. These measures are four out of five attributes added to the Values field

 

 

When I right-click to group by Post_date the Group option is greyed out

Instead of a Post_date, I have tried separating columns by Month 'MM' number (01 = Jan, 02 = Feb, 03 = March) but it doesn't work. 

 

My data is unpivoted so that should not be an issue. 

Data connectivity mode is import. 

 

 

Can someone please help me figure this out?

 

Need Help
Tutorial Requests

3 Replies

  • Docaste's avatar
    Docaste
    Regular Visitor
    1 year ago

    parry2k 

    I'm trying to get this output

    Where each month of revenue (columns in black) are reflected before the measures (columns in blue). So, the measures calculate on the Sum of all months not individually.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    1 year ago

    Docaste what you are trying to achieve is not directly possible, there are few hacks but not straight forward.