Forum Discussion

arnie's avatar
arnie
Helper I
2 years ago
Solved

Matrix hierarchy layout

Hi Everyone,   * I am trying to create a matrix that includes values of "Tonnes Actual" and " $/T" (dollar per tonne). * Figure 1 shows how power bi displays both values through the months of the ...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    Hi arnie ,

    Use a disconnected table and a conditional formula to return the desired calculation based on the value in the  disconnected table. Please see attached pbix for reference.

     

  • arnie's avatar
    arnie
    2 years ago

    danextian - thank you soooo much. It's exactly what I needed as a solution, love it.

     

danextian's avatar
danextian
Super User
2 years ago

Hi arnie ,

Use a disconnected table and a conditional formula to return the desired calculation based on the value in the  disconnected table. Please see attached pbix for reference.

 

  • arnie's avatar
    arnie
    Helper I
    2 years ago

    danextian - thank you soooo much. It's exactly what I needed as a solution, love it.