Forum Discussion

ChirSidh's avatar
ChirSidh
Helper II
3 years ago

Add dual value to Power BI Matrix Visual

How to add two different values in a Power BI matrix visual, one at the project level and the other at the subproject level. I have Project and Sub Project (Work order) in rows and month number in c...
Need Help
ChirSidh's avatar
ChirSidh
Helper II
3 years ago

Hi, they are in  different tables but they are related with Project number 

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi ChirSidh ,

If they're related with project column, you put Work Order No column, month column and Current Forecast Multiplier column in a table visual, can they be displayed in the correct result? If not, please modify the relationship.

 

Best regards,

Community Support Team_yanjiang

  • ChirSidh's avatar
    ChirSidh
    Helper II
    3 years ago

    Hi, i cant put Work order in column as in my real data set i have more than 100 projects and 1000 WO's. So i need to keep Project and Work order in Rows only and Months in the Column as shown in my file

    • v-yanjiang-msft's avatar
      v-yanjiang-msft
      Icon for Community Support rankCommunity Support
      3 years ago

      Hi ChirSidh ,

      I don‘t mean for you to change the matrix visual, I just suggest you check if each Work Order-Month pair can get a Current Forcase Multiplier value. If not, you should modify the relationship.

       

      Best regards,

      Communtiy Support Team_yanjiang

      • ChirSidh's avatar
        ChirSidh
        Helper II
        3 years ago

        Hi, Can you show me how this is done in your PBIX file, i am not able to attach PBIX file here sorry