Hi everyone,
I know how to create a dynamic chart title based on the contents of a cell.
What I want to achieve is a Pivot Chart dynamic chart title based on a slicer that is showing Week Commencing dates, I show the last 13 weeks, so what I want is to be able to show the first date and the last date of all 13 weeks selected.
In other words 17/06/2018 to 02/09/2018 - trust this makes sense.
I have read that you can do this in Power BI, but I do not have access to this.
Thanks in advance
I know how to create a dynamic chart title based on the contents of a cell.
What I want to achieve is a Pivot Chart dynamic chart title based on a slicer that is showing Week Commencing dates, I show the last 13 weeks, so what I want is to be able to show the first date and the last date of all 13 weeks selected.
In other words 17/06/2018 to 02/09/2018 - trust this makes sense.
I have read that you can do this in Power BI, but I do not have access to this.
Thanks in advance
Last edited: