hello,
i want to highlight the max and mn values in the line chart
the line chart has the measure :
note : i cant find conditional formating for the data colors
Solved! Go to Solution.
Hi, @lawada
You can try to create two measures and add them to line chart.
Like this:
maxcount = IF ( [placed orders] = MAXX ( ALL ( orders ), [placed orders] ), [placed orders] )
mincount = IF ( [placed orders] = MINX ( ALL ( orders ), [placed orders] ), [placed orders] )
Hi,
Here is how to do this:
1. Create a format measure:
e.g.
3. Create this rule and change the chart to a line chart:
4. End result
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
how can i apply this foramting measure to my current measure as im using function (userelationship) to filter by columns from other tables?
Hi,
You can place your current measure as the second condition of MAXX and MINXX. The idea is to compare the values on a table level and get the values we want to higlight into variables. You also need to modify the _table variable accordingly.
Proud to be a Super User!
can you explain how to adjust the _table variable part accoording to the measure i provided? as im using mote than one single table so i cant use summarize function . also i still dont have conditional formatting for the data colors as i mentioned in the pictures i attached
Hi, @lawada
You can try to create two measures and add them to line chart.
Like this:
maxcount = IF ( [placed orders] = MAXX ( ALL ( orders ), [placed orders] ), [placed orders] )
mincount = IF ( [placed orders] = MINX ( ALL ( orders ), [placed orders] ), [placed orders] )
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!