Forum Discussion

VJR1998's avatar
VJR1998
Frequent Visitor
4 years ago

%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...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

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's avatar
MuniqueCrespo
Icon for Helper I rankHelper I
4 years ago

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's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    Hi,

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

    • MuniqueCrespo's avatar
      MuniqueCrespo
      Icon for Helper I rankHelper I
      4 years ago

      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's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        4 years ago

        Hi,

        You may download my PBI file from here.

        Hope this helps.