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

    Hello yingyinr

     

    Please try again.

     

    Thank you

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hello yingyinr

        I'm looking for a Stacked Column Chart per my example Tab - Attempt 2 Slicer B.  The issue I'm having is with Slicer B. Currently it's set at 8/1/2020 - 8/26/2021.  I would like to set it at 8/1/2021 - 8/26/2021 and it show me the prior year stack for 2020 with the Flag Yes and No). Is that possible? If I set the Slicer B to 8/1/2021 - 8/26/2021, I only get the Stacked Column Chart for 2021. I would like to see both - the Stacked Column Chart for 2020 with Flag ( Yes, No) and a Stacked Column Chart for 2021.

         

        I can get it to work with a clusted column chart, but not with a stacked colunm chart.

        Regards,