proportion

Good Afternoon I need help to work out how to show the proportion of days taken per category. I have posted how this looks in Excel however I am struggling to create a Measure in Power BI to replicate it. My data is in one large table, called Sheet 1! The example below: first 2 columns are...

Hi All, Not sure how to explain this too well but here goes... I have a SS much like the below example, where i have a list of peoples incomes, in this example, 100 & 100. I then have a field with a total of expenses, in this example, 500. I then use a formula as shown below, which looks at...

<tbody> on tue wed thu fri sat sumn total available F <colgroup><col width="64" style="width: 48pt;" span="8"><tbody> F 34 34 34 34 34 34 34 G 54 54 54 54...

I have this problem with mini charts.... for some reason sometimes the charts are out of proportion internally. Try this example: Insert in 5 cells across these values 6 3 3 4 5 and the insert a bar minichart. The bars corresponding to the numbre 3 are out of proportion. I have an image...

Hi all, I am facing some issue while setting up formula for target based incentive. Problem set has 3 classes: Below 80% achievement - payout is 0% at 92.5% achievement - payout is 100% Between 80% to 92.5% - payout is proportion (basically the gap between 80% and 92.5% represents 100%) At...

Hello all, I have two series of value I need to the proportion to figure out which is the value I should put based on my old valuations. I am going to explain better. Based on past series I have the below distribution: <colgroup><col style="width: 100px"><col width="100"><col...

Greetings, I'm trying to create a stacked bar chart, but with the length of the bar adjusted relative to a second series on the primary axis. I'm analyzing the occurance of key terms in the meetings of various departments, but I want the length of each department's bar proportional to the...

I created a 3D column chart comparing data for 2007, 2008, and 2009. With 2009 data appearing towards the front and going back to 2007. Since the chart is 3D, the columns begin in a different position for each year, so that even though the data in the column towards the front is a larger value...