Forum Discussion
Small Multiples Drilldown with hierarchy
To enable drilling down from department to workplace, you will need to adjust the drilldown functionality in your stacked line and bar chart. One way to do this is to add the workplace field as a secondary category axis in your chart.
To do this, click on your chart to select it and then go to the "Visualizations" pane. Click on "Axis" and then select "Category" under "Secondary." From there, add the workplace field as a category axis.
Once you have added the workplace field as a category axis, you should be able to drill down from department to workplace by clicking on the department and then selecting the specific workplace you want to view. You may need to adjust the formatting of your chart to make sure that the workplace labels are legible when displayed on the chart.
Responsive ResidentTo enable drilling down from department to workplace, you will need to adjust the drilldown functionality in your stacked line and bar chart. One way to do this is to add the workplace field as a secondary category axis in your chart.
To do this, click on your chart to select it and then go to the "Visualizations" pane. Click on "Axis" and then select "Category" under "Secondary." From there, add the workplace field as a category axis.
Once you have added the workplace field as a category axis, you should be able to drill down from department to workplace by clicking on the department and then selecting the specific workplace you want to view. You may need to adjust the formatting of your chart to make sure that the workplace labels are legible when displayed on the chart.
I dont have a Secondary Axis
i use that chart
where should i add that?
I had a similar issue and question. I found an alternative solution.
Alternative solution: Create a fields parameter for two or more categories you want to use in your small multiples. Then, add a single-select slicer to the page using the fields parameter and use it as your small multiples data, too. Then, you can switch between the categories using the single-select slicer, effectively simulating the drill-down / drill-up feature.
Let me know if this works for your (and your users') needs!
