cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
avinaash
Advocate II
Advocate II

Need to give an option to select which one is to be drilled out in Power BI Matrix

Assume I have a matrix as shown below,

avinaash_1-1614073386201.png

 

On clicking on any of the base column values, I need first to get a popup like thing before the drill down. In the pop up I need to get list of columns which must be the in the drill down. As shown below, on clicking on "Bas_Col_1".

avinaash_2-1614074361779.png

 

Next, the drill down should happen based on the click on these buttons. For instance, in the below example, I have clicked "Column A".

avinaash_3-1614075537392.png

 

Similarly, on the next drill down rest columns should appear as shown below.

avinaash_4-1614075776787.png

 

Again, whichever column I clicked should be the next drill down. In the below example I clicked the "Column C".

avinaash_5-1614076112117.png

And it should go on. It can go on any combination.

Is this possible? If not, what is the alternative? Are there any third-party visualizations?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

1 REPLY 1
amitchandak
Super User
Super User

@avinaash , I doubt this possible in power bi. Please create an idea : https://ideas.powerbi.com/ideas/

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors