Forum Discussion
Dynamic Group Slicer Selection
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
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
4 Replies
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
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
