Dynamically Highlight Line Chart Series in Power BI

[@alinecarvalho6584]

I'm glad a colleague recommended this video! subscribed!

[@BIElite]

Welcome Aline!

[@MrAszpic]

Spectacular! I made it on a similar way when trying to reproduce some visuals made on datawrapper. The added min & max lines instead of fixed values is a smart move. Thanks for sharing!

[@BIElite]

Awesome Ary! I appreciate the watch

[@MrAszpic]

@@BIElite why didn't you just avoid using the disconnected table and played with the Edit Interactions?

[@BIElite]

Good question, Ary. Going the Edit Interactions route would be fine as well, but it would require removing the filter context for the Max and Min measures. I preferred creating the disconnected table and leaving my measures as simple as possible.

[@LukeBarousse]

You sir, are a Power BI master! 🙌🏼

[@joneskiller8]

Respect! Learned a few hacks, appreciate that. I think the dynamic formatting can also be done with conditional formatting using advanced features by using measures for fields to format the colors.

[@BIElite]

Interesting idea Jones! I'll have to try that out sometime soon

[@Baldur1005]

But I think that was the problem - you cannot use it with line charts. You can modify the markers, but not connectors.

[@BIElite]

Ah yes, I now understand what was meant in the original comment. You can't apply any conditional formatting when a field is present in the Legend well, unfortunately.

[@Baldur1005]

@@BIElite Actually you can, but only to markers - the line between markers is staying fixed. I think it is unrelated to Legend

[@BIElite]

Ah very interesting to note. I don't think I've ever tried the line marker conditional formatting with an item in the legend. I'll have to check that out

[@rjmplq]

Awesome! Thanks for sharing. You'd think Microsoft would include conditional formatting as a native feature of standard visualizations.

[@remib5863]

I like the hack of min and max values, i didn't think of using it! I might try to implement that for the date too as I had a similar case where data is missing for some dates.

[@BIElite]

Very cool, Remi. Hope it works out for your use case.

[@Scorpian22k]

Is it possible to achieve the same scenario using 1 visual only? Will the field parameter help to not change the line colours manually?

[@lape36]

Thanks for an awesome video, Can you also do this with a scatter chart?

[@billmanassas7746]

This is a nice workaround, I would not rate it as great, because so many things could go wrong, for example if you changed the background colour of the page. Also, you should group those two visuals together from the selection pane. Other than that it is thinking out of the box!

[@spilledgraphics]

Awesome stuff Parker , love hacking Power BI ✌😎

[@BIElite]

One of my favorite things to do 😀 Your stuff is great btw. Subscribed!

[@dobrodziej]

@@BIElite Another cool hint from you, I just applied sort of it into MERoD solution with band chart he struggled : )

[@charusamaddar6550]

This is a great work around for line charts. I have a another similar scenario where I have to plot multiline chart using a measure(a KPI by month) by states and as total of all states in the same chart. all highlighted together (For comparison). scrolled through your videos but could not find that trick. If you find it intriguing enough, please let me know how we can achieve that!

[@adrianvicente250]

Awesome. Thank you very much, that was exactly what I was looking for. Could it be possible to dynamically highlight several filters? That would be the next step. Thanks!!

[@BIElite]

Hi Adrian, you sure could by adding extra measures. Simplest solution I can think of quickly would be to offer the user multiple single select slicers. Eg. Selection 1, Selection 2, Selection 3

[@osPA78]

That was freaking awesome!!!!!!!

[@BIElite]

Haha glad to hear Oscar! I agree, this is a lot of fun

[@juanignacioXI]

Awesome trick mate, can u make a video on how to custom that tooltip to show just the value of the line? It would be great, thanks in advance!

[@milimondal7156]

I want to add a target value line for each selection. how to implement that?

[@gabrielajudithlopezgutierr3863]

Awesome tutorial but I have a problem, the filter is not filtering the second chart, I followed all previous steps, creating the selected value and everything, but it's not working

[@Slytherie07]

amazing. thanks for this. im using this now

[@tairusadiq3527]

Truly awesome, such a brilliant concept

[@jorgeestebancamargoforero2625]

Thanks for sharing this Amazing Tutorial it helped me a lot. May I ask, Is it possible to allow multiple selection and picture one or more lines at a time?. I know that selectedvalue() just work for one selection, would it be possible to solve this requirement with some other function?

[@andreeaolah6543]

Can it somehow work with a measure like running total or YTD Sales. What I tried so far, takes into account weekend sales (which are zero), so the line of max or min is not smooth, does not steadily rise. Any suggestions?

[@halilbulut7966]

Awesome, Thank you!

[@sukhomoyb]

Hi Parkar, Is this possible to highlight Max. Value and Min. Value of a Column Chart?

[@riazuddin7493]

Can you please let me know the DAX for counting total staff number at on particular point in time. I have employee data in which date of joining is since 1974 to 2021 is there any way if I select 2019 then the total staff headcount show total staff who were present in 2019 whether or not they joined in 2019 in other words a cumulative total of staff whose date of joining is 2019 and backwards?

[@gxsoft]

VERY GOOD Parker!!!

[@BIElite]

Thank you Gabriel!

[@gxsoft]

Thanks YOU Parker. YOU are really ingenious. I had tried something similar in the past, but it did NOT work. I saw that the key was in the minimum and maximum values, when I saw it, I realized how much I had missed.

[@BIElite]

Haha I've actually tried this and failed many times over the past few years. Finally it clicked! Only takes one time lol

[@gxsoft]

@@BIElite Oh yes, oh yes! thank you for your tell us

[@danjarupath]

Thank you

[@BIElite]

No problem Jay!

[@nehachak]

wooow!! this is just awesome

[@BIElite]

Thanks Neha!

[@datacleaningchallenge2029]

where do you get the data source

[@BIElite]

www.marketwatch.com/investing/stock/tsla/download-data?startDate=2/17/2020&endDate=02/16/2021. You can download a year worth of data for any time range.

[@datacleaningchallenge2029]

@@BIElite love you man. i just subscribe

[@SSM_33]

awesome

[@BIElite]

Thanks said!

[@andreeaolah6543]

Amazing trick! {Heart} for content :heart:

[@danjarupath]

🆒