Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello all,
I am very new to Power Bi as well as for this group.
I have Power BI report which need to show the status of KPI. The data file (Xlsx) is extracting from system and its replace the values in every week. For example for last week file : Project status = Inprogress and this week Project status = Completed.
Assume that I need to show weekly project staus count, and also I dont have the project close date in my file, that files contained only status.
Any method that have experianced in? Highly appriciate your time on this, Thank you.
Solved! Go to Solution.
Hi @amilajay369 ,
As far as I know, Power BI is a read only application and it could only create visuals based on data model. So there should be data you need to help your calculation.
According to your statement, the data will be replaced every week. I think you need to keep all data you need instead of replacing. And then add date in your data source to determind the order of the data.
FX: Table should contain columns as [Date] / [Status].
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Rico, that is what I also thinking to do now. Otherwise no option to save date. Thanks agin for your detailed explaianation.
Hi @amilajay369 ,
As far as I know, Power BI is a read only application and it could only create visuals based on data model. So there should be data you need to help your calculation.
According to your statement, the data will be replaced every week. I think you need to keep all data you need instead of replacing. And then add date in your data source to determind the order of the data.
FX: Table should contain columns as [Date] / [Status].
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |