How to display values of a whole within the same column

[Datafruit]

Hi, 

How would you solve this challenge. I have let's say 100 dollars as salary per day. Now everyday I have to pay rent which is 40 dollars, groceries for 20 dollars and gas for 10 dollars. All of these expenses total 70 dollars.

Now I would like to display these graphically based on salary (100 dollars) and have rent, groceries and gas within the 100 dollar value column, like having a visual budget to see, how much "free" money I have. 

How would one display these within the larger value? Having a clustered column or stacked column chart would not do, as this would display them respectively beside one another or on top and would not give the "correct" feel.

Any help, ideas or comments are appreciated.

[v-chenwuz-msft]

Hi @Datafruit ,

If you do not want bar chart ,you can try pie chart. I assume you have a record sheet, like this.

Then create a Type table via enter data.

I create a measure to calcualte the total of all.

Measure =
VAR _sum =
    SUMX( Records, [Cost] )
VAR _free =
    SUMX( FILTER( ALL( Records ), [Type] = "salary" ), [Cost] )
        - SUMX( FILTER( ALL( Records ), [Type] <> "salary" ), [Cost] )
RETURN
    IF( SELECTEDVALUE( 'Type'[Type] ) = "free", _free, _sum )

You need to be careful to leave the Type in the filter pane unchecked for salary. Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Datafruit]

Hi @v-chenwuz-msft 
Thanks for the reply. But unfortunately I would like a bar chart as the aim is to track how much of the overhead/free amount is per day... 
I know that this is rather tricky and I have not been able to figure out a way to do it now.

Hoping that you have some ideas 🙂

Best
Jaanis

[TheoC]

@Datafruit can you provide an example of what would give the right visual output? Even if you can hand draw what you're after.  I apologise as I am not entirely understanding the output you would want if the two charts you mentioned wouldn't give the right output. 

Thanks in advance. 

Theo

[Datafruit]

Hi, So I was  thinking something like this. That the "separate" items or costs per day are marked within the available cash per day, if that makes sense.