Dynamic Group Slicer Selection

[harib]

Hello Friend's,

I have one requirment . I have a data in the table format . we need to show count of Group wise.

Example : I have a Country, Customer,Product and Region

when i select any Group in slicer that Group values should reflect in the table like below image.

Ex : Picture 1 : If i select country from slicer country group should come in the table including sort 

      Picture 2 : If i select customer from slicer customer group should come in the table including sort

Picture 1

Picture 2

Refrence data 

METRIC_NAME	REGION	COUNTRY	CUSTOMER	TOTAL_COUNT	TARGET_PERCENT
ALL	NAR	USA	LGS INNOVATIONS LLC.	4	80
ALL	NAR	USA	LGS INNOVATIONS LLC.	341	80
ALL	NAR	USA	LGS INNOVATIONS LLC.	2	80
ALL	NAR	USA	LGS INNOVATIONS LLC.	4	80
ALL	EMEA	SAUDI ARABIA	SAUDI TELECOM COMPANY	1	80
ALL	EMEA	SAUDI ARABIA	SAUDI TELECOM COMPANY	81	75
ALL	EMEA	SAUDI ARABIA	SAUDI TELECOM COMPANY	4	80
ALL	EMEA	SAUDI ARABIA	SAUDI TELECOM COMPANY	2	80
ALL	EMEA	SAUDI ARABIA	SAUDI TELECOM COMPANY	5	80
ALL	EMEA	SAUDI ARABIA	SAUDI TELECOM COMPANY	24	80
ALL	NAR	USA	IBT EQUIPMENT PURCHASING LLC	19	80
ALL	EMEA	GERMANY	TI GERMANY GMBH	6	80
ALL	EMEA	QATAR	THALES COMMUNICATION AND SECURITY	1	80
ALL	EMEA	QATAR	VODAFONE QATAR Q.S.C.	5	80
ALL	EMEA	QATAR	VODAFONE QATAR Q.S.C.	24	90
ALL	EMEA	QATAR	VODAFONE QATAR Q.S.C.	24	80
ALL	CHINA	CHINA	SHANXI UNICOM	2	80
ALL	CHINA	CHINA	SHANXI WEISEN NETWOR	7	80
ALL	CHINA	CHINA	SHEN YANG OTRAN SCIE	252	80
ALL	EMEA	GERMANY	TELENT GMBH	7	85
ALL	NAR	USA	TELCOBUY.COM LLC	1093	80

Appriciate if any one help me.

Advance Thanks

[MFelix · Accepted solution]

Hi @harib ,

Check this blog post were you have a detailed description on how to achieve this, although this is based on chart can be reused for table visual also.

If you need any assistance please tell me.

Regards,

MFelix

[Anonymous · Accepted solution]

@harib - 

You can't add/remove columns with a slicer, but you could potentially do the following:

1. Create a copy of the visual for each potential selection.

2. Create a Bookmark for each potential selection, making the selection visible and the rest invisible.

3. Create a Button for each potential selection, to "call" the bookmark which makes the relevant visual appear.

Hope this helps,

Nathan

[v-frfei-msft · Accepted solution]

Hi @harib ,

Using bookmark should be a work around.

[Anonymous · Accepted solution]

@harib - 

You can't add/remove columns with a slicer, but you could potentially do the following:

1. Create a copy of the visual for each potential selection.

2. Create a Bookmark for each potential selection, making the selection visible and the rest invisible.

3. Create a Button for each potential selection, to "call" the bookmark which makes the relevant visual appear.

Hope this helps,

Nathan

[shrimankabra]

You can refer the below link for the same, the same is implemented for a chart. You can implement it in your case too.

https://community.powerbi.com/t5/Desktop/Dynamic-change-in-X-Axis/td-p/86167

[MFelix · Accepted solution]

Hi @harib ,

Check this blog post were you have a detailed description on how to achieve this, although this is based on chart can be reused for table visual also.

If you need any assistance please tell me.

Regards,

MFelix