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

[RandomText]

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?

[ibarrau]

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.

[sturlaws]

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:

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

cheers,

Sturla

[RandomText]

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

[v-frfei-msft]

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

[ibarrau]

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.