How to Transform a LINE CHART into an Insightful KPI VISUAL in Power BI

[@rauljimenez5485]

This is amazing!! Very useful techniques to enhance the story telling of the reports!!! Thank you very much for sharing your knowledge!

[@ExcelFort]

You are welcome 🙏

[@chuckt8246]

This is brilliant! Thank you! It hadn't occurred to me that 1 - just because it's on the Y axis doesn't meant it's a line and 2 - multiple lines does not always mean sub-levels that need to be drilled down.

[@pl4195]

I have a problem excel fort, my line chart is showing all months say from Jan 2020 to Oct 2023 and so does my title as well, but the title should be showing single month (e.g. Oct 2023) based on the date slicer I have selected. May I know how to fix that? many thanks!

[@ExcelFort]

Thanks for watching the video. You need to turn on Single Select on the slicer.

[@Mr143gaurav]

Hi I am trying to use it the Title one but when I am creating the measure it says that the current row not avialable. I am getting this error what may be the cause. "The value for 'Sales' cannot be determined. Either the column doesn't exist, or there is no current row for this column."

[@ExcelFort]

Please share the measure you are trying to use

[@eduardoferreira8893]

Great! Thank you for sharing this great knowledge!

[@ExcelFort]

My pleasure!

[@jhazielpetersen761]

I do not have a trend line option in the visual, may I know how to activate that?

[@michaborodzinski936]

You need to change X-axis Type to Continusous not Categorical

[@teigenxayden]

Excellent example! Thank you! and can we get the templates file?

[@databrainspro]

Excellent one !!! Thanks for sharing

[@ExcelFort]

You are welcome 🙏

[@marcelolacoppola7163]

Great video !!! Thanks, clear, simple, elegant !!!

[@ExcelFort]

You are welcome!

[@abhijitpatil9745]

Unable to get the Min and Max markers.

[@ExcelFort]

Not sure how your model is built and how you have used the measures to get the max and min. Need more details.

[@unnikrishnansanthosh]

excellent one, thank you for sharing

[@ExcelFort]

My pleasure!

[@HealthEdify675]

How did you get the target achieved

[@AbiolaSingHymns]

That's exactly my question.

[@perfectionist6624]

Video after 6months😢

[@ExcelFort]

Thanks for waiting for it! I’ve been busy. I hope you enjoy this one.

[@perfectionist6624]

@@ExcelFort yes thanks