Forum Discussion

uberscore's avatar
uberscore
Regular Visitor
9 years ago
Solved

hierarchy

Hello, Newbie here. I made a bunch of line graphs with data from Google Analytics, for instance the amount of impressions a certain campaign has had. I put the results in a line graph. I then added ...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi uberscore,

     

    If I understand correctly, you put campaign, advertising and keyword in Axis of line chart, and the amount of impressions in Values, right?

     

    When you drill down from campaign level to advertising group level, the X-axis will display the advertising group values. The line value will based on the aggregate function used for Values.

     

     

    Besides, we can drill down all fields at once, or drill down one field at a time. For more information, please refer to this article: Drill down in a visualization in Power BI.

     

    If issue persists, please share some sample data and screenshots about the line chart for our analysis.

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi uberscore,

 

If I understand correctly, you put campaign, advertising and keyword in Axis of line chart, and the amount of impressions in Values, right?

 

When you drill down from campaign level to advertising group level, the X-axis will display the advertising group values. The line value will based on the aggregate function used for Values.

 

 

Besides, we can drill down all fields at once, or drill down one field at a time. For more information, please refer to this article: Drill down in a visualization in Power BI.

 

If issue persists, please share some sample data and screenshots about the line chart for our analysis.

 

Best Regards,
Qiuyun Yu

  • uberscore's avatar
    uberscore
    Regular Visitor
    9 years ago

    Hello Qiuyun_Yu,

     

    Your description is accurate for what I am doing, but it's not what I want to have. I want to be in a situation where the axis has date, the values are impressions and the legend(containing the hierarchy of campaign) allows me to drill down. I looked around on the forum and saw that this is currently a suggestion. I'll go vote there and hope for the best.

     

    Thanks for your reply,

    Uberscore