Forum Discussion
help in matrix visualization
I want help in matrix visualization. I want to have a similar structure in PowerBI. Each team has a budget. I have to add values present under the "Value" column and substract the result from "Total Budget" to get "Budget to be used". Please help me to get this result.
Hi Curious12964
Since Power BI visualizations are built in a way that aggregates values, similar logic applies to pivot tables. To achieve a similar result, each row should have a unique identifier at the category level, which will also dictate the display order. A row number or a date can be used to ensure the data is presented chronologically. This way, it is possible to achieve a result that is almost identical to the desired one.Dax measures :
Total Budget = if(ISINSCOPE('Table'[Row id]),",MAX('Table'[Budget]))
Spent = SUM('Table'[Values])
Budget to be used = if(ISINSCOPE('Table'[Row id]),", [Total Budget]-[Spent])
Pbix is attachedIf my answer was helpful please give me a Kudos and accept as a Solution.
2 Replies
Hello Curious12964 ,
I see the complexity in your visuals because if a row has blanks the corresponding numbers or values cannot be shown against that because there is no filter context present.
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!
Thank You
Dharmendar S
Hi Curious12964
Since Power BI visualizations are built in a way that aggregates values, similar logic applies to pivot tables. To achieve a similar result, each row should have a unique identifier at the category level, which will also dictate the display order. A row number or a date can be used to ensure the data is presented chronologically. This way, it is possible to achieve a result that is almost identical to the desired one.Dax measures :
Total Budget = if(ISINSCOPE('Table'[Row id]),",MAX('Table'[Budget]))
Spent = SUM('Table'[Values])
Budget to be used = if(ISINSCOPE('Table'[Row id]),", [Total Budget]-[Spent])
Pbix is attachedIf my answer was helpful please give me a Kudos and accept as a Solution.
