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.



dharmendars007's avatar
dharmendars007
Icon for Memorable Member rankMemorable Member
1 year ago

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

LinkedIN