How to use an explicit metric in the whole page.

[JoanElGran1899]

Hi Everyone! I'm here again with new doubts to resolve, always keep improving!💪

I want to do some buttonswith filters( but the problem is that is with an explicit metric, which is net revenue and % Margin.)

And I can't put the metric as a filter in the column of filters onthe page. (In the object visual I can, but I want in the whole page.)

Does anyone have any idea of how to doing it?

Thank you very much for trying to help me!!

[JoanElGran1899]

@MFelix 

How do you links the amount with the filter?
Because i did the column and the table but with the slice does not filter.
Kind regards!

[MFelix]

Be aware that this column was created with calculated groups:

https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

If you need I can do a manual with the steps I did for this specific example.

[MFelix · Accepted solution]

Hi @JoanElGran1899 ,

Believe that the best option for this is to use calculation groups and in that way you do not need to create any buttons and can use a slicer, the syntax should be something similar to:

IF( selectedmeasure() >= 80 , selectedmeasure())

Check PIBX file attach with an example for sales but you can then create the other for the margin.