Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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/

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/

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.