In Ms. Excel, when we click on one of the bars, it will automatically select everything that falls within the same category.Is that possible to do it in PowerBi? Sample as below.

Hi Anonymous , According to your requirements, this function can be easily implemented in powerbi desktop. I did the following test: create an identical visual, and then just click the type area below. Then you can get the highlight results of the same category. If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply. Best Regards,Henry If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Bar Chart - Category Selection | Microsoft Fabric Community

9 Replies

v-henryk-mstf
Community Support
5 years ago
Hi Anonymous ,

According to your requirements, this function can be easily implemented in powerbi desktop. I did the following test: create an identical visual, and then just click the type area below. Then you can get the highlight results of the same category.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Anonymous
  Not applicable
  5 years ago
  Aha! Good one! That's only can be done when we select from legend.
  Not possible to have the same results when select one of the bars?
  - v-henryk-mstf
    Community Support
    5 years ago
    Hi Anonymous ,
    
    Yes, if you click on a specific bar, the clicked part will be highlighted, and the same result as above will not be achieved.
    
    Looking forward to your reply.
    
    Best Regards,
    Henry
    
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
samdthompson
Memorable Member
5 years ago
Hello, yes, thats the nature of cross filtering in PBI. its one of the things that makes it such a powerful visulaisation tool.
- Anonymous
  Not applicable
  5 years ago
  When I select one bar, it only selected the bar of that month, not the whole category like Ms. Excel.
  Can you show me how to make it works?
  - samdthompson
    Memorable Member
    5 years ago
    Just click on the category in the legend. that will do it for you
HarishKM
Super User
5 years ago
Anonymous Hey .
Here in power bi ,we genrally do it with slicer selection to slice and dice the data accordingly .Kindly refer below imgae for your reference .

2nd slicer for year 2013 .it will slice and dice 2013 data only in chart .

more image for your reference .
- Anonymous
  Not applicable
  5 years ago
  Thanks for replying. It's not what we wanted to achieve.
  We want to see the capacity lines in one chart with months on axis X.
  - HarishKM
    Super User
    5 years ago
    Anonymous Hey You can do this way .
    
    You can create 2 viz like i have created and both are diffrent level of detail then when will you select anything from bottom chart or top chart it will slice all related category product for you .
    
    Note : once done kindly select viz and go to edit intraction update other chart data to filter from highlighting then it will filter all data otherwise it will highlight.
    picture 1 : filtering top chart from bottom one
    Picture 2 : filtering Bottom chart from top chart
    I thing this will fulfil your requirement and you can use button as well to hide viz.