Forum Discussion
To establish model
Hi All,
i tried to prepare simple PBI report similar as shown below. however i couldnt find a formula "Status - Completed or Not completed" to create "Slicer". can anyone assist me.
Excel report showing the status of publish vs. pending
| No. | Program | Total Doc | Total Publish | % | Total Pending | % | Target Completion |
| 1 | A | 14 | 9 | 64% | 5 | 36% | - |
| 2 | B | 5 | 0 | 0% | 5 | 100% | - |
| 3 | C | 6 | 6 | 100% | 0 | 0% | Completed |
| 4 | D | 12 | 2 | 17% | 10 | 83% | 27.09.2024 |
| 5 | E | 28 | 15 | 54% | 10 | 36% | 15.10.2024 |
| 6 | F | 18 | 18 | 100% | 0 | 0% | Completed |
| 7 | G | 4 | 3 | 75% | 1 | 25% | 20.09.2024 |
| 8 | H | 14 | 6 | 43% | 6 | 43% | 04.10.2024 |
| 9 | I | 8 | 7 | 88% | 1 | 13% | 30.10.2024 |
| 10 | J | 7 | 0 | 0% | 7 | 100% | 15.10.2024 |
| 11 | K | 19 | 4 | 21% | 12 | 63% | 27.09.2024 |
| 12 | L | 11 | 0 | 0% | 7 | 64% | 27.09.2024 |
| 13 | M | 2 | 0 | 0% | 2 | 100% | 11.10.2024 |
| 14 | N | 2 | 0 | 0% | 2 | 100% | 11.10.2024 |
| 15 | O | 2 | 0 | 0% | 2 | 100% | 07.10.2024 |
| 16 | P | 2 | 0 | 0% | 2 | 100% | 07.10.2024 |
| 17 | Q | 2 | 2 | 100% | 0 | 0% | Completed |
| 18 | R | 2 | 1 | 50% | 1 | 50% | 07.10.2024 |
| 19 | S | 4 | 0 | 0% | 4 | 100% | 07.10.2024 |
| 20 | T | 15 | 0 | 0% | 14 | 93% | 04.10.2024 |
| 21 | U | 17 | 0 | 0% | 17 | 100% | 04.10.2024 |
| 22 | V | 13 | 0 | 0% | 13 | 100% | 04.10.2024 |
| 23 | W | 2 | 0 | 0% | 2 | 100% | 04.10.2024 |
| 24 | X | 11 | 0 | 0% | 11 | 100% | 04.10.2024 |
| 25 | Y | 18 | 0 | 0% | 18 | 100% | 04.10.2024 |
Heya,
If I understood your problem correctly, I would simply add a calculated column with the below logic and then use this new column as a slicer:
Slicer = IF('Table'[Target Completion]="Completed","Completed","Not completed")If this solved your problem then please mark it as the solution so others can see it.
Best,
Hi Anonymous
For the slicer, you can create a calculated column :Status_ = IF([Target Completion]="Completed" , "Completed", "Not completed")
To get the graph with not completed as negative values you can create a measure :
Count_status = IF(SELECTEDVALUE('Table'[Status_])= "Completed" ,COUNTROWS('Table'),COUNTROWS('Table')*-1)RESULT :
The pbix is attached
If my answer was helpful please give me a Kudos and accept as a Solution.
5 Replies
Hi Anonymous
Which rows are "not completed here"?Heya,
If I understood your problem correctly, I would simply add a calculated column with the below logic and then use this new column as a slicer:
Slicer = IF('Table'[Target Completion]="Completed","Completed","Not completed")If this solved your problem then please mark it as the solution so others can see it.
Best,