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.
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!
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."
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.
This is amazing!! Very useful techniques to enhance the story telling of the reports!!!
Thank you very much for sharing your knowledge!
You are welcome 🙏
Great video !!! Thanks, clear, simple, elegant !!!
You are welcome!
Great! Thank you for sharing this great knowledge!
My pleasure!
Excellent example! Thank you! and can we get the templates file?
Excellent one !!! Thanks for sharing
You are welcome 🙏
excellent one, thank you for sharing
My pleasure!
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!
Thanks for watching the video.
You need to turn on Single Select on the slicer.
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."
Please share the measure you are trying to use
I do not have a trend line option in the visual, may I know how to activate that?
You need to change X-axis Type to Continusous not Categorical
How did you get the target achieved
That's exactly my question.
Unable to get the Min and Max markers.
Not sure how your model is built and how you have used the measures to get the max and min. Need more details.
Video after 6months😢
Thanks for waiting for it!
I’ve been busy. I hope you enjoy this one.
@@ExcelFort yes thanks