Working with Dynamic slicer

[Anonymous]

Using SELECTEDVALUE and SWITCH functions with a slicer without conection is possible to create a chart showing dynamically these measures.

Value Selection =

VAR Selection = SELECTEDVALUE(KPIs[KPI],"All")

RETURN

Switch(True(),

Selection = "Case Fill Rate",[mCaseFillRate],

Selection = "Supply Perfect Orders",[mSupplyPerfOrder],

Selection = "Perfect Orders",[mPerfOrder],

[mCaseFillRate])

However, if I need to include add more than one measure in each selection i.e. (Case Fill Rate and Case Fill Rate Target) in order to show two series per shot, is that possible?

Each KPI has one different target threshold, so I have to work them in pairs.

Gilly

[v-xuding-msft]

Hi @Anonymous ,

Maybe you can try to add the measure to visual level filters to implement filter values after filtering with slicer.

If it is not what you want, can you please share the sample data and the expected output? Then we can find a way to implement add more than one measure in each selection. According the present statement, I think it is difficult to create a sample to implement it.

Best Regards,

Xue Ding

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

[Anonymous · Accepted solution]

Thanks @v-xuding-msft,

The way I've found is to have two dynamic slicers (one for the KPIs) and other for the KPIs threshold, considering that which KPI has a different threshold, tricky one! So you have to select the KPI and the threshold manually. It would be nicer I could having one slicer selecting both (KPI and KPI threshold in one shot)

Cheers!