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 Experts,
I'm having a situation where need to calculate a KPI ( performance over a week and performance over a month) which should be available as a selection in the dashboard. Weekly KPI is 1350 records processed per person and I'm also not sure how to calculate for month ( this requires no of working days by 270 records processed per day).
team size is 5 persons and individual graphs to be developed.
Data that i have is Total records, person name and date table;
1. what kind of a graph will be suited for this requirement?
2. DAX Calculation of weely and monthly KPI?
3. How to design the switching between week and month in one single report ( Dax )?
Thank you for your support.
Regards,
Laz
Solved! Go to Solution.
This issue is now resolved. Thanks for all your answers. Couldn't assign any points as this was resolved internally.
Hi @Anonymous ,
Firstly, I think the KPI visualization is the best way to display your requirement. There is a document you can reference.
And then, can you please post some sample data and the expected output. I want to know how you calculated the KPI.
Finally, what effects of switching between week and month do you want ? Do you want to filter the measure of weekly and monthly using a slicer?
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your prompt reply.
I'm still learning about the Switch function but still couldn't get the hang of it. I'm using following DAX statement to switch between Week and Month. What I need is something like when i select Week, month figures should blank out and vise versa.
DynamicSelection = SWITCH(true(), [Selection] = 1,'Planning Time'[Weekly KPI], [Selection] = 2,'Planning Time'[Monthly KPI],BLANK() )
Selection is nothing but a table which i manually created which has an Index 1,2 and Week and Month respectively. Then i'm using two measures to calculate week and month. At present moment when i click on week or month i can see on top left of the visualisation ( which is a Gauge) refresh icon appears and disappear but nothing else happens.
Please advise what's the best practice behind creating the Switch ? is Toggle is same as switch or different?
Thanks again
Regards
LW
Hi @Anonymous
Based on your scenario, there is a similar thread you can reference. If you have any issue, please post sample data and the excepted output.
https://community.powerbi.com/t5/Desktop/Dynamic-change-in-X-Axis/td-p/86167
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This issue is now resolved. Thanks for all your answers. Couldn't assign any points as this was resolved internally.
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |