Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
@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 - Let me know if you run into issues. It's essentially a spin on the disconnected table trick!
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!
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.
@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
I voted for it now!
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |