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
Super User
4 years ago

Hi,

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

MuniqueCrespo's avatar
MuniqueCrespo
Helper I
4 years ago

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super 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
      Helper 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
        Super User
        4 years ago

        Hi,

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