Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Drill Through Line Chart Visual

Hi,

I was wondering if we can have drill through a line chart.

 

Suppose, I have a trend of population of a country through the years with population count in Y axis and years on X.

Is it possile to have a drill throughover this chart, where in drill page, I get population trend based on states.

 

I cannot use drill down for this because I want to make chart of say 10 countries and in drill through, I want to show trend of top ten states of that particular country through which I drilled through.

 

Thank you in advance. 

Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous ,

    Based on my test, you could use the drillthrough function.

    Sample file:

    Create below picture in Page 1:

    Create below picture in page 2 and set the drillthrough value:

    You could also download the pbix file to have a view.

     

    Regards,

    Daniel He

1 Reply

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous ,

    Based on my test, you could use the drillthrough function.

    Sample file:

    Create below picture in Page 1:

    Create below picture in page 2 and set the drillthrough value:

    You could also download the pbix file to have a view.

     

    Regards,

    Daniel He