Please don't tag individuals in a thread, anyone who can help can reply
For your problem, why not create a calculated field to derive the month number and return the result, then add this to the graph as a line ( I think you're trying to create something like a bullet chart) to show performance versus target.
Something like this should work:
case DATEPART('month', [your_time_dimension_here])
when 1 then 10
when 2 then 23
when 12 then 69
Don't SUM this, make sure it's MIN or MAX.
The fastest/simplest way might be to create a dummy record for January, with a NULL or 0 for the data.
I have attached the a image here.
Here the requirement line the Target line (Black color) should be static even though if you apply filter. For example if you apply year filter 2014 that may not have 60 tenure let say it has only 34 tenure then the target line varies according to the tenure as target calculation based on the tenure.
Is there any way to fix the target line irrespective of tenure changes. I think if we fix the target based on axis values as i fixed axis the target will be fixed.
I am attaching the workbook for your reference.
I don't know the answer, but I think I know what's going on. The Target (copy 2) calculated field is ultimately based on data dimensioned by Cohort Year.
When you filter Cohort Year the underlying data is filtered out of the view and the line is affected.
I'd be guessing (it would take some work to test) if you could have the Target calculation in another datasource that is not associated with year, but if it's based on yearly data you will get the same result in the end anyway
Hi Chris McClellan,
As you suggested I tried to implement the dashboard with two different data source but still there should be column to join the data source but I have again tenure column to join. Even if I applied filters to primary data source eventually that filters the data in secondary data source because we have join based on tenure column.
Please refer the attached workbook for the same scenario.
I have thought but I don't it work or not. Generally in Data blending we have Primary data source and secondary data source they will joined in way like how left join works. for example If primary data source contains 60 tenures and secondary having 40 tenures if they blended the All 60 tenures will be returned because it's left join. Will it work?
I tried this but I couldn't achieve this , Is my understanding about blending correct?
Blended Datasources.twbx 130.6 KB