Forum Discussion
%GT for each year format help
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?
14 Replies
Use the "100% Stacked Bar Chart" visual.
this does not work
Hi,
It will depend upon your data layout and measures that you have written. Share the download link of your PBI file.
Hi Ashish, would you know how to solve this issue?
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.
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,
WinnizDoes 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
Hello, please see the solution to your problem below. Ashish has sent the solution. Please mark that reply as the answer. Thanks
