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

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



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

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/



!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.