Forum

Forums
Public Forums - For...
General Excel Quest...
one graphic with di...
 
Notifications
Clear all

one graphic with different period in time for KPI (customers)

 
General Excel Questions & Answers
Last Post by Mynda Treacy 6 years ago
2 Posts
2 Users
0 Reactions
89 Views
RSS
 Alina Mates
(@alinam)
Posts: 4
Active Member
Topic starter
 

Hi Mynda,

I have another issue to solve, I kindly ask you if you can help me, I don't know how can I modelling the information to show as you can see in the attach picture.

I did it in excel, base on a data base, I created another sheet in my file with a separate table, inserting formulas (sumifs ...) but in Power BI I don't know how to do this.

I attach a short version of my database to see the data columns
How can I arange / modeling in PBI the measures to do this graphics?
I have to see in the same graphic dates for: before period, after that week by week, after that what we have in current week, ant finally the situation for the Pilot YTD (average data). I don't know if I can put all togheder in the same graphics.

e.g.graphics-dashboard-.PNG

Can you show me for one of them, please?

In attach file you have data for customers

Thank you

Best regards,

Alina

 
Posted : 11/10/2019 7:51 am
 Mynda Treacy
(@mynda)
Posts: 4762
Member Admin
 

Hi Alina,

The forum is for specific Excel questions you're having difficulty with. I can't build your whole report, sorry.  It sounds like you need to learn how to write DAX measures. I recommend you take my Power Pivot course to get your skills up to speed for using Power BI: https://www.myonlinetraininghub.com/power-pivot-course

Mynda

 
Posted : 11/10/2019 9:11 pm
Forum Jump:
  Previous Topic
Next Topic  
Share: