Forum Discussion
Drill down multiple values based on same date
Hi all,
Is it in some kind of way possible to have a bar chart based on a date but with multiple values to drill down on?
For exmple I have a dataset containing invoicing and cost for the last 12 months. Is it possible to create one bar chart which shows invoicing for the last 12 months and after drilling down it shows the cost instead of the invoicing but for the same time period?
HI ManuelGeiger,
Power bi will try to aggregate your value fields based on current axes and legends fields. BTW, the current drill features not able to drill multiple values.
For your requirement, I think you need to shape and do transform on your table at the query editor side or create a summary table to group your records based on specific category fields. Then you can use these new fields and values to create visuals and switch between different axis levels to check different records based on-axis group. (axis: date, invoice number, value field: amount)Regards,
Xiaoxin Sheng
2 Replies
ManuelGeiger , In the drill-down try to ignore the filter using all. and again try to have a range.
or On the main page have the visual on let say date from date table and on drill have it on date from the fact table now you can ignore date from the date table easily.
HI ManuelGeiger,
Power bi will try to aggregate your value fields based on current axes and legends fields. BTW, the current drill features not able to drill multiple values.
For your requirement, I think you need to shape and do transform on your table at the query editor side or create a summary table to group your records based on specific category fields. Then you can use these new fields and values to create visuals and switch between different axis levels to check different records based on-axis group. (axis: date, invoice number, value field: amount)Regards,
Xiaoxin Sheng
