Issue with Dynamic Slicer and Dynamic Conditional chart format

[Anonymous]

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 down the target line. I managed that creating two extra columns (Above e Below the target) in order to have two series on the chart.

I am using a disconnected slicer to dynamically change the measures in the chart (below):

Value Selection =

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

  RETURN

  Switch(True(),

  Selection = "Case Fill Rate AT",[mCaseFillRateAT],

  Selection = "Case Fill Rate BT",[mCaseFillRateBT],

  Selection = "Supply Perfect Orders AT",[mSupplyPerfOrderAT],

  Selection = "Supply Perfect Orders BT",[mSupplyPerfOrderBT],

  Selection = "Perfect Orders AT",[mPerfOrderAT],

  Selection = "Perfect Orders BT",[mPerfOrderBT],

  [mCaseFillRateAT]).

Using Control key I can select more than one option, however I cannot see the different colours because the selector considers as one value (Value Selection).

Any suggestion how I can have conditional format in this chart still using my dynamic selection?

Cheers,

Gilly

[Anonymous]

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])

[v-lili6-msft · Accepted solution]

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

[v-lili6-msft]

hi, @Anonymous 

Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Could you please share a simple sample pbix file and your expected output?

Best Regards,

Lin

[Anonymous]

Hi @v-lili6-msft ,

I am uploading the current chart that I have (pic 1) and the one that I would like to have (pic 2). Not sure whether using this logic is possible to have this done.

Pic 1: