Ian MacLeod
New Member
Hello.
I wonder if someone can help me. I'm struggling with this one.
I have a Dashboard (having studied Chandoo's Dashboard (Excel School 2.0 Dashboards) course.
I have initially used Power Query to ETL the Source data and Loaded it all to a Data Model.
Then I am using the Data Model to create Pivot Tables (as per Chandoo's course)
Everything works perfectly except for one thing.
On the Dashboard I am using a Timeline to filter on dates.
The DB looks allows the user to view the YTD Actuals against the FY (Financial Year 12 months) Total Forecast to see the value and % of the Year's Forecast has already been spent.
The idea is for the user to select various periods, say month 1 - 10 or 4 -6 or a single month in the year.
How can I have the Timeline filter on selected periods? But always keep the FY Forecast as the 12 months to:
1. always show the Full Year Amount,
2. calculate remining spend value and %,
3. calculate the % spent at that Timeline selected.
The Timeline uses a separate table in the Data Model.
I've tried to use a DAX expression in the Pivot Table in question by using CALCULATE, but I can't seem to be able to use REMOVEFILTERS, that is, from the Timeline field.
I'm running out of time for this to be done for my employer.
Please can someone help me?
I'm afraid I am unable to attached any files, as my employer has a need for tight security.
Please ask me direct questions, if my description of my issue is not clear enough to help resolve.
Thank you in advance
Ian MacLeod
I wonder if someone can help me. I'm struggling with this one.
I have a Dashboard (having studied Chandoo's Dashboard (Excel School 2.0 Dashboards) course.
I have initially used Power Query to ETL the Source data and Loaded it all to a Data Model.
Then I am using the Data Model to create Pivot Tables (as per Chandoo's course)
Everything works perfectly except for one thing.
On the Dashboard I am using a Timeline to filter on dates.
The DB looks allows the user to view the YTD Actuals against the FY (Financial Year 12 months) Total Forecast to see the value and % of the Year's Forecast has already been spent.
The idea is for the user to select various periods, say month 1 - 10 or 4 -6 or a single month in the year.
How can I have the Timeline filter on selected periods? But always keep the FY Forecast as the 12 months to:
1. always show the Full Year Amount,
2. calculate remining spend value and %,
3. calculate the % spent at that Timeline selected.
The Timeline uses a separate table in the Data Model.
I've tried to use a DAX expression in the Pivot Table in question by using CALCULATE, but I can't seem to be able to use REMOVEFILTERS, that is, from the Timeline field.
I'm running out of time for this to be done for my employer.
Please can someone help me?
I'm afraid I am unable to attached any files, as my employer has a need for tight security.
Please ask me direct questions, if my description of my issue is not clear enough to help resolve.
Thank you in advance
Ian MacLeod