Forum Discussion

sarab3's avatar
sarab3
New Member
1 year ago

Line and stacked column chart with table AND drill down

Hi everyone,


I'm familar with the line and stacked column chart with table visual but I'm hoping to have the ability to drill down and display the updated related data in the table below. Is anyone aware of how to have both the drill down and the stacked bar chart with a table all in one? It seems the Shared Axis can only handle one field.

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi sarab3  ,
    According to your description, your requirement is that after bricking in the main table, you also want the table visual object to be changed as well, and based on that you want to be drilled not just a single field, but may need multiple fields, right?
    If you say you want more than just one field to drill down, you can customize the hierarchy to combine two fields into one field hierarchy and drill down to achieve your needs:

    After we put the hierarchy of fields into our X-axis, we can see that the drilldown should successfully appear, and at this point we are applying a little bit of the relationship between our filters, and you can update the data, based on the master table!

    If you have any other questions, you can check out the pbix file I uploaded, I hope it helps, and I'd be honored if I could solve your problem!

    Hope it helps!

    Best regards,
    Community Support Team_ Tom Shen

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

    • Soc3's avatar
      Soc3
      Icon for Helper I rankHelper I
      1 year ago

      Hi Anonymous ,

       

      Thanks for your reply. The "Line and Stacked Column Chart with Table" is the visualization tool I was referring to which doesn't have the drill down ability. This specific visualization tool displays values in the table below that align with the bar chart. It's helpful when users are interacting with the dashboard and selecting specific bars, the values in the table always visually align. But it lacks the ability to drill down.