Forum Discussion
Drill-through report
Hi,
There are around 10 articles, and for each article I have numerator and denominator value for each month.
I need to display the percentage for all 12 months (i.e numerator/denominator * 100) of current year in a column chart chart (not stacked) for all articles (report01.png)
When user click anywhere in chart it should convert in stack chart (report02.png)
Means, view report01 should be change in report 02 dynamically.
| Article | Numerator | Denominator | Month |
| AT&T | 0 | 0 | January, 2016 |
| Besmaya | 1 | 2 | January, 2016 |
| Carrol County | 2 | 5 | January, 2016 |
| Crossrail | 0 | 0 | January, 2016 |
| Google Fiber (US) | 0 | 0 | January, 2016 |
| Hummel Station | 18 | 12 | January, 2016 |
| Kosovo | 0 | 0 | January, 2016 |
| Muscat | 0 | 0 | January, 2016 |
| Riyadh | 0 | 0 | January, 2016 |
| Stonewall | 0 | 0 | January, 2016 |
| AT&T | 0 | 0 | February, 2016 |
| Besmaya | 11 | 11 | February, 2016 |
| Carrol County | 20 | 20 | February, 2016 |
| Crossrail | 0 | 0 | February, 2016 |
| Google Fiber (US) | 0 | 0 | February, 2016 |
| Hummel Station | 28 | 28 | February, 2016 |
| Kosovo | 0 | 0 | February, 2016 |
| Muscat | 0 | 0 | February, 2016 |
| Riyadh | 0 | 0 | February, 2016 |
| Stonewall | 0 | 0 | February, 2016 |
| AT&T | 0 | 0 | March, 2016 |
| Besmaya | 21 | 22 | March, 2016 |
| Carrol County | 200 | 500 | March, 2016 |
| Crossrail | 0 | 0 | March, 2016 |
| Google Fiber (US) | 0 | 0 | March, 2016 |
| Hummel Station | 8 | 2 | March, 2016 |
| Kosovo | 0 | 0 | March, 2016 |
| Muscat | 0 | 0 | March, 2016 |
| Riyadh | 0 | 0 | March, 2016 |
| Stonewall | 0 | 0 | March, 2016 |
| April, 2016 | |||
| May, 2016 | |||
| June, 2016 | |||
| July, 2016 | |||
| August, 2016 | |||
| September, 2016 | |||
| October, 2016 | |||
| November, 2016 | |||
| December, 2016 | |||
| January, 2017 | |||
| February, 2017 | |||
| March, 2017 | |||
| April, 2017 | |||
| May, 2017 | |||
| June, 2017 | |||
| July, 2017 | |||
| August, 2017 | |||
| September, 2017 | |||
| October, 2017 | |||
| November, 2017 | |||
| December, 2017 |
report01report02
2 Replies
I'm not exactly sure what you are trying to do and what measure you are using for the line?
However if you have all 12 months on the x-axis and you click January
the way drill down works it will give you the details for Janury and only January it will not give you all months again
The way you order the fields in the Shared Axis - that's what it will go to next when you click a column
You may have to use 2 charts (one for time and one for category) - they will filer each other and show the details you want.
Hi anupagrawal77,
Based on my understanding, you have two reports, when you click anywhere in report01, the report01 will display as report02, right?
I agree with Sean’s opinion. In Power BI desktop, drill down action is occur in the same visualization between different hierarchies. Please refer to this article: Drill down in a visualization in Power BI.
Currently, we are not able to replace one visualation with another visualation dynamically by drill down action. In your scenario, you need to create those two visualtions in the page, instead of interactive each other within report01.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
