Forum Discussion

rayinOz's avatar
rayinOz
Helper III
9 years ago
Solved

How to hide bars when drilling down?

Hello PowerBI users!

 

I'm wondering if it is possible to hide bars when drilling down.

 

In the image below, step 1 is when I click on a bar (Chancellory). This is the Division bar chart. In the chart below, the Organisation chart, I see bars (dimmed) that are not part of Chancellory, step 2. I'm wondering how to hide these as they don't apply and it will make the chart easier to read.

 

Thoughts? 

 

 

 

 

 

 

 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi rayinOz,

    Do you click the Chancellory section in the Division bar chart to filter Organisation chart? If so, click on the Division bar chart, turn on “Edit interactions” under Format ribbon, then choose “Filter” in the Organisation chart, this way, you will get expected result. You can review the example below.


    Thanks,
    Lydia Zhang

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi rayinOz,

    Do you click the Chancellory section in the Division bar chart to filter Organisation chart? If so, click on the Division bar chart, turn on “Edit interactions” under Format ribbon, then choose “Filter” in the Organisation chart, this way, you will get expected result. You can review the example below.


    Thanks,
    Lydia Zhang