Forum Discussion

dommyw277's avatar
dommyw277
Icon for Helper V rankHelper V
3 years ago

Week on Week Top 10 By Category

Hi,

So i want to create a trending report on Top 10 Categories week on week. However, , I want to show the Top 10 week on week not the Top 10 over a current month eg 4 weeks.
So week 39, top 10, week 40 top 10 etc...

Any idea how to do this?

Need Help

5 Replies

  • Uzi2019's avatar
    Uzi2019
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi dommyw277 
    Can you share some screenshot  of excel how you want it???
    would be easier for us to understand.

      • dommyw277's avatar
        dommyw277
        Icon for Helper V rankHelper V
        2 years ago

        Hi, sorry i meant to add heres how i want it in power BI but in one graph. Each month the Top 10 categories are different. If i do it by month resolved by Top 10 , it just grabs the top 10 overall , does that make sense?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi dommyw277 ,

    In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_Binbin Yu