Forum Discussion

Ramendra's avatar
Ramendra
Icon for Helper IV rankHelper IV
4 years ago
Solved

Show Data points as table option while clicking over a single bar or column

I have seen a option and if I select this then we can get the details from a bar or column chart by clicking over a single bar or column. But this only work in edit mode in power bi service. Similar ...
  • v-jingzhang's avatar
    4 years ago

    Hi Ramendra 

     

    I think this is by design. In Power BI Desktop, only when you select a visual and activate the Data point table icon in Data/Drill ribbon, you can left click to see the table. When this icon isn't activated, left-clicking will let you pick a data point and see its interactive effects with other visuals too. As Power BI Desktop is a report design tool for report authors, it's just like when you are in edit mode in the service. It's similar to when you switch on Show data point as a table option in Edit mode in service. 

     

    For report viewers (in report view mode), left-clicking will let you select a data point. This is by default and cannot be changed currently. When a visual has a hierarchy and is in Drill Down mode, left-clicking will let users drill down that data point. 

     

    I recommend that you raise up a new idea about functionality to change/customize the left-click behavior of visuals for report users. You can post your idea at Ideas (powerbi.com) and let other people vote it up. Currently I found there are some similar ideas but for drill feature. 

    Microsoft Idea - Enable Drillthrough on Left Click/Mobile

    Microsoft Idea - Enable Double Left-Click Drill Down, Double Right-Click Drill Up

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.