Forum Discussion
Creating Hierarchy Slicer For Specific Values Only
p0wer_user add another column in your table for the group, I'm sharing how to do it in Dax but preference is always to do it in PQ or at the source.
Group = LEFT ( Table[Company Name], 1 )In slicer, drop group column and company name column and it will take care of it.
Thank you parry2k for your prompt reply.
Hi p0wer_user ,
parry2k has led you on the right path. I saw that you did not respond to this reply and made an example to help you understand the issue better. I hope our replies will be helpful to you.
1. Add a new column.group = LEFT('Table'[Company Name],1)
2. Put group and Company Name into the slicer.Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you parry2k for your prompt reply.
Hi p0wer_user ,
parry2k has led you on the right path. I saw that you did not respond to this reply and made an example to help you understand the issue better. I hope our replies will be helpful to you.
1. Add a new column.
group = LEFT('Table'[Company Name],1)
2. Put group and Company Name into the slicer.
Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.