Measure outside column hierarchy

Question

Dear Allhow 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.&nbsp;

amitchandak · Answer

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/811692https://www.youtube.com/watch?v=veCtfP8IhbIhttps://exceleratorbi.com.au/dax-unichar-function-power-bi/

anonymous · Answer

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

amitchandak · Answer

Anonymous , That you can not do without workaround
&nbsp;
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/1354591https://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
&nbsp;
&nbsp;
&nbsp;
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-64b0b4a4090ehttps://www.youtube.com/watch?v=6LUBbvcxtKA

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Are these months in same column or different columns? Please show some sample data.
&nbsp;
Best Regards,
Jay

Forum Discussion

Measure outside column hierarchy

4 Replies

Related content

Date hierarchy

Measure outside column hierarchy in Matrix visual

Manage visuals outside Pbix

Creating Hierarchy for measures

Date Hierarchy