Forum Discussion

Curious12964's avatar
Curious12964
Regular Visitor
1 year ago
Solved

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 "...
Tips and Tricks
  • Ritaf1983's avatar
    Ritaf1983
    1 year ago

    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 attached

    If my answer was helpful please give me a Kudos and accept as a Solution.



Ritaf1983's avatar
Ritaf1983
Super User
1 year ago

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 attached

If my answer was helpful please give me a Kudos and accept as a Solution.