Skip to main content
Microsoft Idea

Power BI

New

Setting left click behavior for data points to unlock tens of different UX scenarios

Vote (15) Share
Mustafa Asiroglu's profile image

Mustafa Asiroglu on 22 Jan 2023 12:33:53

Allowing report designers to set default left click interaction of data points can unlock tens of new UX possibilities with a single feature.


This feature can be added to all visuals which includes a data point selection. E.g., Table, Matrix, Map, Pie Chart, Bar Chart, etc.


Proposed UX Mockup


Proposed options with key benefits and use cases:


  • Make Selection is the default option which is current behavior of all visuals. It allows filtering or highlighting other visuals.
  • Drill Down option sets default interaction to make drill operation in current visual. (Already available functionality using header icons)
  • Drill through option fulfills one the most requested feature from community (forums and ideas.powerbi.com): single, left-click drill through from any data point.
  • Page navigation option unlocks new possibilities including dynamic page list in a grid, and each navigation without adding navigation button and second click requirement.
  • Bookmark option allows using any visual as bookmark navigator, now with data/measure driven bookmark lists, allowing even RLS!
  • Web URL option unlocks existing Web URL conditional formatting option in table and matrix to any visual, including maps, charts etc.
  • None option allows report creator to make any visual read only, similar to Power BI Dashboard tiles, without adding extra transparent layers to force any visual to be not interactive.
  • Behave Transparent option brings additional UX tricks, such as adding a watermark on top of a visual but allowing selection on the visual at bottom or adding a custom icon on top of slicer to make erase icon always visible. (pointer-events: none)


Comments (3)
Mustafa Asiroglu's profile image Profile Picture

Paul Jackson on 30 Jan 2023 10:12:41

RE: Setting left click behavior for data points to unlock tens of different UX scenarios

Left click drillthrough is a urgent need. This feature is available in Microstrategy and Qlik.

Mustafa Asiroglu's profile image Profile Picture

Mustafa Asiroglu on 22 Jan 2023 15:03:39

RE: Setting left click behavior for data points to unlock tens of different UX scenarios

Some of related ideas and user feedbacks (part 2):Drill through on Table Values - Microsoft Power BI CommunityGrey out or disable a visual? - Microsoft Power BI CommunityHow to implement Page Level Security by using Row Level Security (RLS) in Power BI Desktop | by Allen Tseng | MediumPage navigation buttons with RLS - Microsoft Power BI CommunityMicrosoft Idea (powerbi.com)Disable the selection of a visual? - Microsoft Power BI CommunitySolved: Make a Table ReadOnly - Microsoft Power BI Community

Mustafa Asiroglu's profile image Profile Picture

Mustafa Asiroglu on 22 Jan 2023 15:02:33

RE: Setting left click behavior for data points to unlock tens of different UX scenarios

Some of related ideas and user feedbacks:Is there any way to do drillthough (not use right ... - Microsoft Power BI CommunityMicrosoft Idea (powerbi.com)Is there any way to do drillthough (not use right click and click the drillthrough page)? | Power BI Exchange (pbiusergroup.com)Microsoft Idea (powerbi.com)Microsoft Idea (powerbi.com)