Display percentage of total column value in Stack bar chart

[Anonymous]

Hi All,

Below is the measure that I am using in the Stack column chart.

Last 6 month Order = CALCULATE ( COUNT( Fact_Table[Order_Id] ), DATESINPERIOD ( 'Date Dimension'[Date], ENDOFMONTH( 'Date Dimension'[Date] ), -6, MONTH)). 

Month Year = CONCATENATE(Upper(Fact_Table[Related Month]),CONCATENATE(" ",right(Fact_Table[Year],2)))

Which are working fine.

In addition to that I need to show % of total order for each section in a bar in the Tooltip.

I am struggling with the DAX calculation for Percentage.

Is it possible to display Percentage value in the Tooltip?

I am not able to add the filter in my DAX correctly for the "Level" to get the percentage of total column value.

Thanks In Advance

• 

[amitchandak]

Have you tried to put your % measure on Tooltip. Of percent measure calculation has problem

[Anonymous]

Hi @amitchandak

No I am struggling with the DAX. Not getting the correct Filter () with ALL/ALLEXCEPT/ALLSELECTED.

[Anonymous]

Order PCT% =

CALCULATE(DIVIDE ( [Total Order ID],

CALCULATE ( [Total Order ID],
ALLEXCEPT(Fact_Table,Fact_Table[Level] ),
ALLSELECTED(Fact_Table[Month Year])), 0 ),
DATESINPERIOD('Date Dimension'[Date],ENDOFMONTH('Date Dimension'[Date]),-6,MONTH))

It is giving me Percentage of Grand Total, which I do not want.

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/Percentages-to-multi-line-report/m-p/378504#M172040