Forum Discussion
Drill down based on the legend
I'm working with a stacked column chart that shows the trend of different securities over time (months). The x axis is the date range, y-axis dollar value, and legend is the type of security. I'd like to drill down into the security type, to then see the specific security but every time I do it drills down based on the x axis (date range). Is there anyway to set the drill down to legend?
Hi jmartin98 ,
Refer this ,to use the drill mode, the Power BI visual must have a hierarchy.
According to your description, here are my steps you can follow as a solution.
(1) This is my test data.
(2) We can create a calculated column.
type = "security"(3) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi jmartin98 ,
Refer this ,to use the drill mode, the Power BI visual must have a hierarchy.
According to your description, here are my steps you can follow as a solution.
(1) This is my test data.
(2) We can create a calculated column.
type = "security"(3) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.