Forum Discussion
Highlight the maximum and minimum point on a line chart
Hi there,
I have a data table with information about sales date and total sales in different region/subregion/market. I was trying to create a line chart showing how total sales changed over time(by month/year) for the differen region/subregion/market. Is there a way for me to highlight the highest and lowest point on line chart with Power BI?
I've tried Note and Event but it doesn't seem to work.
If you select your visual and look in the "Visualizations" pane, you should have a button for "Analytics", to the right of "Fields", and "Format" buttons.
In the Analytics section you can easily add Min and Max lines, with the caveat being that the min/max lines you can add are for specific items charted, and not all items as a group.
If you need a min/max line for every item on the chart, then I would recommend taking a look at that, as it's pretty quick and easy to add min/max lines.
However, if you need a single min/max line representing the highest and lowest points among everything charted, you might consider this: either in a measure or perhaps a little reference table, compare all the values among the charted items and find and save the mininmum and maximum points. Then throw those onto your visual. You should then be able to go back to the Analytics tab and reference them, producing a "Min" line for the minimum value, and a "Max" line for the maximum value.
2 Replies
If you select your visual and look in the "Visualizations" pane, you should have a button for "Analytics", to the right of "Fields", and "Format" buttons.
In the Analytics section you can easily add Min and Max lines, with the caveat being that the min/max lines you can add are for specific items charted, and not all items as a group.
If you need a min/max line for every item on the chart, then I would recommend taking a look at that, as it's pretty quick and easy to add min/max lines.
However, if you need a single min/max line representing the highest and lowest points among everything charted, you might consider this: either in a measure or perhaps a little reference table, compare all the values among the charted items and find and save the mininmum and maximum points. Then throw those onto your visual. You should then be able to go back to the Analytics tab and reference them, producing a "Min" line for the minimum value, and a "Max" line for the maximum value.Hi Mohawk,
Thank you so much for your help ;D
