%GT for each year format help

[VJR1998]

Im currently trying to make a graph which shows the percentage total for each year in cancelled bookings.

I have set it up like so but need to change it so each year is showing the percentage out of 100. Rather than what it is doing currently where the 100% is spread over all 5 years.

Ideally like this but with multiple years on display:

Is this possible?

[MuniqueCrespo]

Hello, please see the solution to your problem below. Ashish has sent the solution. Please mark that reply as the answer. Thanks

[MuniqueCrespo]

Does Anyone know the answer to his question? I am struggling with the same issue. 

I need the line chart to show each individual year GT%, not the overall GT percentage. So each year would be total 100%. 

for example: the line chart would show sales code XYZ with  60.61%, 36,23%, 22.22% with legend Fiscal Year 

[v-kkf-msft]

Hi @VJR1998 ,

Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[Ashish_Mathur]

Hi,

It will depend upon your data layout and measures that you have written.  Share the download link of your PBI file.

[MuniqueCrespo]

Hi Ashish, would you know how to solve this issue?

[Ashish_Mathur]

Hi,

What do you want to show on the X-axis?  I cannot understand the visual you want to create.  Share the download link of the PBI file and also show the expected visual. 

[MuniqueCrespo]

Hi, 

here is what I am trying to do in pbi. I only have the Apps #, i need to be able to create the % column that would total 100% for each year.I need to do this in pbi

[Ashish_Mathur]

Hi,

Share the download link of your MS Excel file in which you have created the Pivot Table.

[MuniqueCrespo]

hi, Apparently I cant attach a file here. there is no button that I can use. 

SalesCodes Apps # Fiscal Year
A1 20 2021
A1 25 2022
A2 9 2023
A2 19 2022
A2 9 2021
A1 6 2023
A3 5 2023
A4 12 2022
A5 3 2023
A6 3 2023
A3 7 2022
A5 3 2021
A5 6 2022
A4 1 2023
Unassigned 1 2021

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[MuniqueCrespo]

Ashish, thank you so much! it worked perfectly!.

[Ashish_Mathur]

You are welcome.  If my previous reply helped, please mark that reply as Answer.

[lbendlin]

Use the "100% Stacked Bar Chart"  visual.

[MuniqueCrespo]

this does not work