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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
RandomText
Helper II
Helper II

Is it possible to let user change x-axis and first table column?

Hi,

 

I'm remaking our old Qlikview reports to Power BI and on Qlikview it's possible to make a graph or table with ability for user to change x-axis or first table column.

 

With that round arrow it's possible to select year, month or day. Is it possible to do something like that on PBI? 

I have an idea with different objects and playing with buttons and bookmarks, but maybe there's easier path?

 

 

 

5 REPLIES 5
ibarrau
Super User
Super User

Hi! there is a way very long to explain, so please check this video teaching how to do it.

https://www.youtube.com/watch?v=n-OWNaCUU0o

 

Hope this helps,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

sturlaws
Resident Rockstar
Resident Rockstar

Hi, @RandomText,

 

there is functionality for this, although not as a slicer. You can use the functionality for drilling down and up in hierarchies in visuals:
Is it possible to let user change x-axis and first table column.PNG

 

It is possible to create a solution with slicer as well, but that will be a far more complex solution

 

cheers,

Sturla

Hey! That works, how about table columns? Any ideas?

Hi @RandomText ,

 

Currently it is not supported to use drill down in table visual. However, I suggest to use drill through to work around.

 

Btw, There is an idea about that you can vote it up to make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12444531-drill-down-and-tables

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Unless you find a Custom Visual that let you change columns in table, I don't think you are going to be able in that case.

 

Regards,

If the last post helped, then please consider Accept it as the solution to help the other members find it more quickly.


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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