topic Re: Select item from slicer by coding in DAX Commands and Tips

Select item from slicer by coding

Dreamer_Argento — Mon, 25 Oct 2021 12:42:32 GMT

How can select an item from slicer by coding?

Thanks

ERD — Mon, 25 Oct 2021 20:48:06 GMT

Dreamer_Argento , you mean get selected value from slicer in code and use it further?

Dreamer_Argento — Mon, 25 Oct 2021 20:56:54 GMT

Dear ERD I want to select a value using Dax simulating a user clicking on a slicer.

ERD — Mon, 25 Oct 2021 21:17:06 GMT

Dreamer_Argento , well, if you mean some particular value, it could be something like

...

DimProducts[Category] = "Beverage"

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

Anonymous — Mon, 25 Oct 2021 22:26:00 GMT

If you want that certain measure is forced to certain selection you can use as calculate modifier.

For example if you have measure: Sum('orders'[Salesamount])
You can force it the certain selection for example:

Calculate(Sum('orders'[Salesamount]),'customer'[Customer Name]="Microsoft")

Other option is to force visuals that use the measure as visual filtter

Choose the selections and lock it

Hope this helps!