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

Thank you , but there is a problem with this when i add multiple months in the columns as showin in my first message , for all the months it is showing the same number, i think it is just taking the max of sub project values.  please see my screenshot 

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

Hi ChirSidh ,

Are the [Work Order No] column and month column in the same table or are they related? If so, the MAX function will extract the current value for the pair, otherwise it will extract the max value.

 

Best regards,

Community Support Team_yanjiang

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