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.

     

amitchandak's avatar
amitchandak
Super User
2 years ago

arnie , if you want the measure above, you need to create a calculation group and use that in visual 

 

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0

 

You now create them in Power bi desktop

 

Model explorer public preview with calculation group authoring| Measure Slicer: https://youtu.be/VfxfJJ0RzvU

arnie's avatar
arnie
Helper I
2 years ago

Hi Amit, thanks for that but it doesn't solve my query. I need the MMM-YY on the columns, not the rows. 

I don't need my measures to be in a slicer. Your video shows how to set up MTD, QTD, YTD, which is not relevant to what I asked for.