Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

  • 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

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      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:

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      v-lili6-msft
      Community Support

      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