Forum Discussion
Helper Irepresent data in percentage the chart for the numeric values
I am new to the Power BI. This the stacked column chart shown with IgA and IGL on the basis of site with the numbers represented for IGA and IGL. Could you please let me know how to show it in percentage for IGA and IGL?
if IGA, IGL are values of column A1
You need to create a new measure and use that. Assume you are using measure M1
divide([M1], calculate([M1], removefilters(Table[A1])) )
if they are two measures then you need measure like
IGA % = Divide([IGA],[IGA] + [IGL])
IGL% = Divide([IGL],[IGA] + [IGL])
if you need % of total
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
Hi rocku2008_1985 ,
You can select the down arrow-- Show value as – Percent of grand total:
Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
if IGA, IGL are values of column A1
You need to create a new measure and use that. Assume you are using measure M1
divide([M1], calculate([M1], removefilters(Table[A1])) )
if they are two measures then you need measure like
IGA % = Divide([IGA],[IGA] + [IGL])
IGL% = Divide([IGL],[IGA] + [IGL])
if you need % of total
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
Hi rocku2008_1985 ,
You can select the down arrow-- Show value as – Percent of grand total:
Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.