Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
arnie
Frequent Visitor

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 year.

* Figure 2 is how I actually want the data to display through the months of the year - "Tonnes Actual" through the year followed by "$/T" through the year.

* How do I get power bi to display my data according to Figure 2 please? At the moment, I am creating a measure for each of the values for each of the months, which seems inefficient and unprofessional.

 

arnie_0-1716346123249.png

Any advice or alternative workaround would be greatly appreciated.

 

kind regards,

Arnie

2 ACCEPTED SOLUTIONS
danextian
Super User
Super User

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.

danextian_0-1716355434520.png

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

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

arnie_0-1716358866456.png

 

View solution in original post

4 REPLIES 4
danextian
Super User
Super User

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.

danextian_0-1716355434520.png

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

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

arnie_0-1716358866456.png

 

amitchandak
Super User
Super User

@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

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. 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.