Forum Discussion
Add dual value to Power BI Matrix Visual
Hi ChirSidh ,
My solution is similar with amitchandak 's, I create a sample to clarify it.
Sample:
If you want to show Column1 in Project and show Column2 in Sub_project, create a measure as below:
Measure =
IF (
ISINSCOPE ( 'Table'[Sub_project] ),
MAX ( 'Table'[Column2] ),
MAX ( 'Table'[Column1] )
)
Put the measure in matrix Values, get the correct result:
I attach my sample below for your reference.
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
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
Hi, they are in different tables but they are related with Project number
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