Forum Discussion
Helper IIgnore dimension on a chart
Hello I'm new to Power BI
I have a bar chart in which I display sales by Product name
I want to display on another bar the ratio of sales to Total sales
Please advise on how to accomplish the second bar of ratio of sales to total sales
2 Replies
SabineOussiSkilled Sharer
If a percentage does the job, use the solution provided to you here http://community.powerbi.com/t5/Desktop/Help-with-charts/m-p/27470 and change the format to percentage under "Modeling" tab.
The percentage of each month to total sales will be presented under each bar.
v-sihou-msftMicrosoft Employee
Hi alihijazi,
If you want to add a bar to display ratio sales of total, you need to add a calculated column to show percentage of total along with each product. The expression can be like;
SalesRatio:=Table[Sales]/CALCULATE(SUM(Table[Sales]),ALL(Table[Product]))
Then you can include this data field in you bar chart.
Regards,