How to show percentage of total by x-axis value not grand total

[Aimeeclaird]

Hi, I have created a table that shows the % of responses received in a survey from January, June and the % change. 

I want to include a stacked area chart (shown below) to visual the January and June data as percentages however it is showing the % of the grant total, not for each of the months.

I've included an annonymised/simplified version of my data here, PBI Example data 050821.xlsx (screenshots are from live data not example)

How can I represent the % total by survey cycle instead of the grant total of the entire data set?

[Anonymous]

Hi @Aimeeclaird 

Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards

Community Support Team _ Ailsa Tao

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

[Anonymous]

Hi @Aimeeclaird 

Is the data you provide to create the measure from 050821.xlsx? I tried it with this data and the formula provided by SU, and everything displayed was the same as expected. Did you apply other filters ? Can you provide your pbix file ?

Best Regards

Community Support Team _ Ailsa Tao

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

[ryan_mayu]

@Aimeeclaird 

pls see the attachment below to check if this is what you want

[Aimeeclaird]

Hi @ryan_mayu 

Thanks for the reply (again!).

Looking at the file you've attached, this is working as I want. However when I have replicated your measure in my file it isn't working?

My file: 

Your file:

Please can you advise?

[ryan_mayu]

@Aimeeclaird 

could you pls provide your pbix file?