Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Stacked Column Chart with PY and CY view

Hello PBI Community Good Day!     I have a demo PBIX if that will help, please advise    Thank you    
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Also, I forgot to mention, I can get it to work with a cluster column chart with the dynamic slicer at the top. I'm trying to enhance the view with a stacked column chart adding the Flag (Yes and No) by year 2020 vs 2021 in a stacked column chart. More details in the attached .pbix.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

    I can't download your file due to I have no proper permission... You can refer the method in the following link to share the file with me. Thank you.

    How to upload PBI in Community

    Best Regards

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello yingyinr

       

      Please try again.

       

      Thank you

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Anonymous ,

        I updated your sample pbix file(see attachment), please check whether that is what you want.

        1. Create a measure as below to get the sum value for prior year

        Sum of usage quality for prior year = CALCULATE(SUM('PBIXDD2'[usage quantity]),SAMEPERIODLASTYEAR('Calendar'[Date]))

        2. Apply the above measure on Visual B to replace the original one

        Best Regards