Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
HI all,
I have a measure that shows the count of not overdue tasks. I need it to show the percentage instead.
This is the measure:
The KPI should compare data from previous year. Could you also check that the target measure is correct please?
ID | Name | Opening Date | Completion Date | Task Type | |
PT00001 | Name 00001 | 24/08/2023 | 01/02/2024 | Project | |
PT00002 | Name 00002 | 11/09/2023 | 28/02/2024 | Task | |
PT00003 | Name 00003 | 22/09/2023 | 24/12/2023 | Assignment | |
PT00004 | Name 00004 | 13/10/2023 | Support Ticket | ||
PT00005 | Name 00005 | 11/09/2023 | 09/01/2024 | Project | |
PT00006 | Name 00006 | 06/10/2023 | 18/10/2024 | Task | |
PT00007 | Name 00007 | 19/10/2023 | 02/02/2024 | Assignment | |
PT00008 | Name 00008 | 16/11/2023 | 20/11/2023 | Support Ticket | |
PT00009 | Name 00009 | 17/11/2023 | Project | ||
PT00010 | Name 00010 | 20/11/2023 | 21/11/2023 | Support Ticket | |
PT00011 | Name 00011 | 21/11/2023 | 01/12/2023 | Support Ticket | |
PT00012 | Name 00012 | 22/11/2023 | 22/11/2023 | Support Ticket | |
PT00013 | Name 00013 | 09/12/2023 | Project | ||
PT00014 | Name 00014 | 24/12/2023 | 09/01/2024 | Task | |
PT00015 | Name 00015 | 18/01/2024 | Assignment | ||
PT00016 | Name 00016 | 20/01/2024 | 28/01/2024 | Support Ticket | |
PT00017 | Name 00017 | 10/01/2024 | 20/01/2024 | Support Ticket | |
PT00018 | Name 00018 | 31/01/2024 | 11/04/2024 | Task | |
PT00019 | Name 00019 | 22/02/2024 | Assignment |
Because I can't upload a .pbix file, I add other formula to help you build the data set as in my .pbix file.
Hi @Sonnet ,
After my testing, I found that the percentage cannot be directly dragged into the KPI visual for display.
If you want to learn more about KPI visuals, please see:
Key Performance Indicator (KPI) visuals - Power BI | Microsoft Learn
If you want to display ‘Not OverdueTasks’ as a percentage, please try:
NotOverdueTasks = FORMAT(DIVIDE(
CALCULATE( COUNTROWS('Sheet1'), FILTER( 'Sheet1', [Overdue] = FALSE() )),
CALCULATE(COUNTROWS('Sheet1'),ALL(Sheet1))
),
"Percent")
I have not found any problems with your 'Prev1Year' for the time being, and the logic is correct.
If you have any further questions please feel free to contact me.
pbix file is attached.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
User | Count |
---|---|
21 | |
19 | |
12 | |
10 | |
9 |
User | Count |
---|---|
30 | |
25 | |
15 | |
13 | |
10 |