matrix visual show only one value and total as first column

[Anonymous]

Hi 

I have matrix visual, added Qty Sold and Revenue to Value. But user request is to display only Revenue for each month and Total Qty in the front for entire peiord. Is this possible or need to change the visual to achieve my requirement. thanks

Month		23-Jan	23-Feb	23 - Mar
Product	total Qty Sold	Revenue
XYZ	200	20000	34000	45000	99000
ABC	250	30000	35000	54000	119000
PRQR	350	40000	34000	60000	134000

[Anonymous]

Hi, Thanks for suggestion. but in both cases DAX functions are hard coded with column names, in my case it will be months in the table. So it will be changing after each month.

I tried wrod wrap off and hide qty column for each month. but my understanding when new month comes after refresh will show the qty column since it not hidden. Is there a way it can be conditional formatted to keep it hidden. 

thanks

[amitchandak]

@Anonymous , seem like

you are looking for a Hybrid display with Matrix Column and measure

https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc