Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 a hierarchy to the graph, which allows me to look at the results on a campaign level, advertising group level, and keyword level.
I came across a problem here. On the highest level, campaign, it shows me the results for campaigns per day. So that means i got the amount of impressions on the y-axis and date on the x-axis.
If I drill down to a lower level, say advertising group, the Y-axis remains, however the x-axis dissapears. Instead of showing the results per day, it sums up the total amount of impressions making the result a single dot, as opposed to a line graph. What am I doing wrong?
Solved! Go to Solution.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |