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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Serge_van_Dun
Frequent Visitor

I can't drill on columns - cursor/selection disappears when moving down from 'Rows' to 'Columns'

Hi,

 

I have a matrix visualisation where you can drill down on rows and columns.

In Power BI Desktop this is no problem.

But when I publish it and try to select the 'Drill on Columns' via PowerBI.com I can't because when I move my cursor down the selection disappears before I can click on 'Columns'

 

cant drill on columns.png

 

Does anyone know how to deal with this?

 

Kind regards,

Serge

1 ACCEPTED SOLUTION

Hi @Anonymous

 

I indeed stored numeric values in the columns.

But I put it in a hierarchical order:

Year

  Month

    Week

      Day

 

Matrix Rows and Columns.png

 

I also just found out that it does work when I use Chrome.

Edge also works.

It doesn't work when I use FireFox...

 

 

Kind regards,

Serge

 

 

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

HI @Serge_van_Dun,

 

I think you column stored text or numeric value, right?

If this is a case, current drill feature only works on date or other custom hierarchy columns, please transform your column to date and turn on time intelligence option. 

 

Regards,

Xiaoxin Sheng

Hi @Anonymous

 

I indeed stored numeric values in the columns.

But I put it in a hierarchical order:

Year

  Month

    Week

      Day

 

Matrix Rows and Columns.png

 

I also just found out that it does work when I use Chrome.

Edge also works.

It doesn't work when I use FireFox...

 

 

Kind regards,

Serge

 

 

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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