Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All. I'm reasonably new to power BI (Last 2 months), but an expireneced excel person. @XX years . 🙂
the forum has been great source of guidance to getting my first dashboard up and running - so thank you all.
OK my problem
I want to create a standard line graph showing a weekly accumlative target vs an actual accumlative (Dummy date is no issue ) - but my data pionts are text. - and relate to when test are being executed.
So my easy option will be to create the table manually in excel and upload 😞 - But I was looking to have it automated.
I have created the bellow formula That checks if the if the test has been executed and retuns the week it ws executed (Week 1, Week 2, Week 3, Week 4
Hi @Anonymous ,
Week of execution = if(or([Execution_status]="Passed",[Execution_status]="Failed"),'Executed vs Execution Date'[Date of Execution],"")
measure = calculate(sum(@@[@@@]), filter(Allselected(@@@[@@@] <= "text" )))
I was not able to understand above measure formulas, I cannot see [Execution_status] and [Date of Execution] in above posted tables. Please illustrate your scenario with sample data (all necessary table and formulas) and desired output. How to Get Your Question Answered Quickly
Best regards,
Yuliana Gu
Hi Yuliana Gu - OK sorry I guess the request was not as straight forward as it could be. How can I upload the Excel fiels and Power bi dashboard ?
Hi @Anonymous ,
You can upload the Excel file and sample PBIX file onto OneDrive, and paste the shared link here. Do mask sensitive data before sharing.
Best regards,
Yuliana Gu
LInk to excle files and dashboard
Hi Yuliana Gu
LInk to the files is above. Hope it helps
I want to create the LIne graph - from the data in the files without creating a sperate file
Terry,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |