Forum Discussion

ChirSidh's avatar
ChirSidh
Icon for Helper II rankHelper 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
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
Icon for Helper II rankHelper 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
      Icon for Helper II rankHelper 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 

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

        Hi ChirSidh ,

        Simply create a table visual and put Work Order column and Month column in it. If they are related, they will have some overlap in the same row. Otherwise the visual will broken.

        Best regards,

        Community Support Team_yanjiang