Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Complex Matrix - is this even possible??

Hi, I'm trying to replicate an Excel matrix of data using Power BI. I'm very new to PowerBI and have probably bitten off more than I can chew as my first project, haha.   The data I'm trying to re...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

 

Can you post some data if it is not company confidential to google or one drive and share the link here.

 

Please also share the output you expect from the data.

 

Cheers

 

CheenuSing

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous 

    Thanks for your reply. I didn't know how to send files so I just worked on a solution myself.

     

    I'm slowly getting there, which is encouraging. I've built a number of 'helper columns' inside my model and am using these to get most of what I need. When I'm back in the office I will post an image of where I'm up to. I still have a few things I'd like to solve that you may be a Le to assist with.

     

    Cheers

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous 

    I have managed to create a matrix with most of what I need. I've dropped the idea of the "Selected Month" column headings and just running with YTD.

    I was wondering if you knew a way to remove the circled (in RED) column headings if they have blank data? This would pretty much finish this project off.

     

    Matrix - remove circled columns if blank

    Cheers