Forum Discussion
ChirSidh
3 years agoHelper II
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...
v-yanjiang-msft
3 years agoCommunity Support
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
3 years agoHelper II
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-msft3 years agoCommunity Support
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