To establish model

[Anonymous]

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

[MNedix · Accepted solution]

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,

[Ritaf1983]

Hi @Anonymous 
Which rows are "not completed here"? 

[Anonymous]

Hi @Ritaf1983,

All except row 3, 6 & 17

[Anonymous]

All except row 3, 6 & 17

[Ritaf1983 · Accepted solution]

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.

[MNedix · Accepted solution]

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,