Forum Discussion
Issue with Dynamic Slicer and Dynamic Conditional chart format
Hi Experts, I am using a Line and Clustered column chart to plot measures that can be below or above the line target. The challenge is to have a conditional format whenever the measure is up or d...
hi, Anonymous
The forum is under maintenance, and I don't notice your reply.
If you want a line in the chart, just create a measure and drag it into Line value field, what is your difficult point of it.
Could you share a simple pbix file for us have a test?
Best Regards,
Lin
Hi v-lili6-msft ,
This is the code I am using in the Valeu Selection in the slicer.
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])
hi, Anonymous
The forum is under maintenance, and I don't notice your reply.
If you want a line in the chart, just create a measure and drag it into Line value field, what is your difficult point of it.
Could you share a simple pbix file for us have a test?
Best Regards,
Lin