Measure outside column hierarchy

[Anonymous]

Dear All

how can i create measure column that display "Amount" difference between this month and last month outside column hierarchy and display up arrow if amount increase from last month middle if amount no change and down arrow if amount decrease like this.

[Anonymous]

Hi @Anonymous ,

Are these months in same column or different columns? Please show some sample data.

Best Regards,

Jay

[amitchandak]

@Anonymous , You can use conditional icon formatting. Of you can use unichar with color

refer

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692
https://www.youtube.com/watch?v=veCtfP8IhbI
https://exceleratorbi.com.au/dax-unichar-function-power-bi/

[Anonymous]

the first one , how can i display amount difference of 2 month outside month column hierarchy.

[amitchandak]

@Anonymous , That you can not do without workaround

if 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

for MOM difference refer

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA