Forum Discussion

Shree_185's avatar
Shree_185
Icon for Helper I rankHelper I
4 years ago
Solved

Barchart Help for monthly Trend

Hi everyone,

 

I am trying to create Barchart on a monthly basis like the below excel screenshot. I get a monthly Snapshot like below. 

 

Daily Snapshot in DB sample 

 

StatusCountDate
Backlog Trend121/1/2022
Opened501/1/2022
Resolved1501/1/2022
Closed2001/1/2022
Backlog Trend102/1/2022
Opened402/1/2022
Resolved702/1/2022
Closed1502/1/2022
Backlog Trend103/1/2022
Opened503/1/2022
Resolved1503/1/2022
Closed3003/1/2022

 

 

 

Want to create a visualization like the below in Power BI using snapshot data

 

Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Shree_185 ,

     

    Sure. You can download my test pbix file from below.

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    4 years ago

    Shree_185 see attached pbix file and tweak it as you see fit

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

     

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Shree_185 ,

     

    You can try below operations:

     

    For more details about this below, you can read below blog:

    Line and Clustered Column Chart in Power BI

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Shree_185 ,

     

    Sure. You can download my test pbix file from below.

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.