Matrix only shows columns for one value

[Anonymous]

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?

[Greg_Deckler]

@Anonymous  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/963588

[Anonymous]

Thanks @Greg_Deckler , Im gonna try it out! 

[Greg_Deckler]

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

[Anonymous]

Hi @Greg_Deckler 

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


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"? 

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

Thanks!
 

[Greg_Deckler]

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.

[amitchandak]

@Anonymous , 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

[Anonymous]

I voted for it now!