Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@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
Hi @harib ,
Using bookmark should be a work around.
Hi @harib ,
Using bookmark should be a work around.
@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
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
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |