'Show a set of metrics in a table/matrix upon a metric group selection - Power BI

I have a set of metrics, e.g. sales revenue, sales volume, churn rate, customer number, etc. All of them can be grouped to, for example, sales-related, product-related, etc.

The requirement is that there should be either a drop-down menu or chiclet-like buttons with groups. Then, when 'product' is clicked, only a set of relevant metrics is selected in the table -in our example, # of products. When 'sales' is clicked, only a set of relevant metrics is selected in the table - in our example, # of customers, # of sales, revenue.

I came across 'selectedvalues', however, it works only when you want to show one metric. I was thinking about bookmarks but then, bookmarks become messy when filters get applied. What could be other solutions?

The sample is at https://drive.google.com/file/d/1E3qJyOv11xSOlVRHAL9uq2C1Zho-g3zc/view?usp=sharing



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source