cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MIchri
Resolver I
Resolver I

Matrix only shows columns for one value

Hi all,

 

I have a matrix table and in values I have amount for purchase and amount for budget. If I use month as column it splits up both purchase and budget per month. Can I split only purchase per month and leave budget as total value?

 

Udklip.JPG

1 ACCEPTED SOLUTION
Greg_Deckler
Super User IV
Super User IV

@MIchri  Why yes you can! I invented The New Hotness for just this purpose. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




View solution in original post

7 REPLIES 7
Greg_Deckler
Super User IV
Super User IV

@MIchri  Why yes you can! I invented The New Hotness for just this purpose. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




View solution in original post

Thanks @Greg_Deckler , Im gonna try it out! 

 

@MIchri  - Let me know if you run into issues. It's essentially a spin on the disconnected table trick!


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Hi @Greg_Deckler 

Not quite sure if Im doing it correctly but 1) I created a new table "Custom Hierarchy".
Udklip3.JPG

2) I then created a measure using "BudgetteretForbrug" as the value I want to sum amd dates Im using - perhaps I should be creating the date hierarchy in table "Calender_G_LEntries" instead of creating a new table "Custom hierarchy"? 

Udklip1.JPG

However, in my last line "__Month" is not being found: 
Udklip2.JPG

 

Thanks!
 

 

Looking at your code, your __Month variable is only defined within the code up until the RETURN statement that follows it. After that the rest of the code cannot "see" the __Month var. Hopefully that helps. So you would need to redefine it essentially somewhere that it can be "seen" by that line of code.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




amitchandak
Super User IV
Super User IV

@MIchri , What you looking for a Hybrid table. That is not supported yet. Try some custom visual

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

 

Vote for :https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39773011-hybrid-table

Hybrid.png



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

I voted for it now! 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors