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 Team,
Here, the requirement is to change the color of line or somehow we need to differentiate in color in line chart by using the numeric slicer value.
Expecting an output like below.
Now, I achieved above by hard coding the dax value instead of dynamic selection based on week number n above slicer.
Dax formula ( calculated column ) =
Hi Peter_Jeyaraj_l
As I know, for line chart, you need to use static legend value to change the line color, so workaround are like below
You could create two meausres for line chart based on slicer value like below
more than max = var maxselcet=CALCULATE(MAX(slicer[Date]), ALLSELECTED(slicer[Date])) return if(MIN('table'[Date])>maxselcet, BLANK(),SUM('table'[Column 2]))
less than max = var maxselcet=CALCULATE(MAX(slicer[Date]), ALLSELECTED(slicer[Date])) return if(MIN('table'[Date])>maxselcet, SUM('table'[Column 2]), BLANK())
Or you could create a clustered column chart, then create a measure like below
Measure = var maxselcet=CALCULATE(MAX(slicer[Date]), ALLSELECTED(slicer[Date])) return if(MIN('table'[Date])>maxselcet, "#50C7C7","#CCA3E3")
use this in column chart's colditional format like below, then click line chart, it will change like below
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for your response.
I tried and still see some challenges as i have all the info in same table. like below
Do i need to create any reference table to achieve the above
Deliver Quarter | Operating Weeks | Measure |
2018-3 | 7 | 100 |
2018-4 | 8 | 120 |
Regards,
Peter I
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |