Drillable line chart with temporal x-axis

[po]

Hi,

Have a line chart with yearwk ( on calendar table)  on x-axis and wish to have it drillable such that can go from country to region to city. (country, region and city a hierarchy on geographic table)

Doesn't look like can have a drillable legned i.e start's country drills thorugh to region then to city.

Any thoughts on how best to achieve above such that can drill down to if try put the geographic hierarchy beneath the yrwk on x-axis.

Thanks

[v-juanli-msft]

Hi @po 

How about this visual?

i create a join table with "geographic table" and "calendar table"

Table = CROSSJOIN('geographic table',VALUES('calendar table'[year/week]))

Then add columns from this table to the "Matrix" visual.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[po]

Thanks for reply.

[v-juanli-msft]

Hi @po 

Is this problem sloved?

If not, please let me know.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[po]

Hi,

Looking to do this in line chart rather than matrix visual and is it possible to have drillable line chart without cross/cartesian join as woudl be quite a lot of data.

Ideally the line chart would start at highest level with yearweek from calendar table on x-axis  would see following 

1) Highest level country value by year/week

2) When select drill see a line for each of the regions by year/week 

2)  when the select drill see a line for each of the cities by year/week.

Thanks

[v-juanli-msft]

Hi @po 

It should be possible.

Look at my simple test.

Add columns in the "Axis" field as below

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[po]

Hi,

Thanks for reply.

Was looking to see if possible to have year/week along the x-axis such that could see 2 lines (one for each country at the same time a and b  - is this possible?

Thanks

[v-juanli-msft]

Hi @po 

Do you like something like this?

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[po]

Hi,

Thanks for update.

Yes but looking to have the legend change as drill down the levels

i.e top level one line

  next level legend country 2 lines as you have

  next level legend is region

  netx level legend is city

Is this possible?

Thanks