Line chart with two dimensions at x-axis issue....

[Anonymous]

Hi all,

I have an issue with line chart, as i am not able to plot two dimensions(Phase&approved date) at x-axis.

i have attached the sample data with  mock up chart, Please try to resolve the issue.

Thanks in advance.

[Gysbert_Wassenaar · Accepted solution]

What you want isn't possible in a single line chart. It cannot have two dimensions at the x-axis. You either need to combine the two dimensions into one. Or you can try text-in-chart objects (add those on the Presentation tab) or use Text objects and place them below the line chart.

Here's what it can look like if you use a calculated dimension:

Here's the expression for the calculated dimension:

=dual(

  If([Date Apporoved]=aggr(nodistinct max(total <Phase> [Date Apporoved]),Phase)

  OR [Date Apporoved]=aggr(nodistinct min(total <Phase> [Date Apporoved]) ,Phase),

  Phase

  ,'            |') & '    ' &  [Date Apporoved]

  ,[Date Apporoved]

)

[Anonymous]

Thanks gysbert wassenaar..