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

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.