Forum Discussion

Lakhani04's avatar
Lakhani04
Frequent Visitor
1 year ago
Solved

Assistance Required - Power BI Visual Matrix

Hello Everyone, I hope you're doing well. I have a quick query regarding a Power BI matrix visualization. I’m trying to create a table with the following setup: Rows: Assignment Group Columns: Y...
Need Help
  • antfr99's avatar
    antfr99
    1 year ago

    Hi Tejas

     

    Ok, great to hear that there is some progress. I took another look to see if I could get rid of the empty columns . I could only find a solution in Power Query and this was the result : 

     

     

     

     

    In general the steps taken are as follows :  Identifies the Maxmonth and two months before ( Query : MaxMonthQuery  ) , which joins with the Grouped average per assignment group ( Query : GroupedAverageQuery ) . This then finally joins with the MaindataQuery ( filtered to show only 3 months prior to max date of the data ) to merge the average SLA% per group.

     

    For the updated file see the same folder I placed the other Power BI files in. 

     

    Hope this helps

    Antonio