Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
Hi @v-lili6-msft ,
This is the code I am using in the Valeu Selection in the slicer.
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, @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
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |