compare two measure in time with detailed categories

[dreamcatcher90]

Hi,

is there any possibility to achive something like I draw on the attached picture? in detail, for each month we have the total cost on left and reported costs in one of the reporting system with detailed percentege of cost categories (one of the categories should show lack of data (the brightest one) compared to total costs, so both measure should be always equal)

 

Regards

[v-yuezhe-msft]

@dreamcatcher90,

Based on my test, I cannot get an exact same chart as the one you draw. However we can use a line and stacked column chart as a workaround. New a line and stacked column chart and fill the columns in the chart as the picture below.

 

Regards,
Lydia

[dreamcatcher90]

hi,

@v-yuezhe-msft thanks a lot for your replay. I know that I can present this in that way, but this is insufficient for business, life.. 🙂

but maybe from diffrent point. In your example, you assumed that you know the value of category D (missing value to the full value of Total Cost), how can we calculate such a value for a given month when we do not know it and display it together with other categories like you do on one chart?

Regards

[v-yuezhe-msft]

@dreamcatcher90,

I am not very clear about  your expected result. Please share sample data of your table here and post expected reult.

Regards,
Lydia