Dynamic Slicers (a la Tableau)

[garynorcrossmmc]

Hi all,

I am trying to replicate a report for our organization that was previously created in Tableau and contains dynamic slicers, as shown in the screenshot below.  

The slicers are for Row Groupings and Column Groupings, and are populated with multiple dimensions, such as Compensation Grade, Rating, Job Family and others.  Can this be accomplished in Power BI?  I have tried multiple other suggestions on this forum and have had no luck.  Thanks in advance!

[V-lianl-msft]

Hi @garynorcrossmmc ,

Based on your description, what you want is dynamic grouping through slicers.

You can refer to this blog:

https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-bi... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[daxer-almighty]

Everything is possible in Power BI with a little bit of creativity but I can't give you any answer since there's not really enough data to act upon.