Dynamic axis chart with pivot tables

[Minakshi]

Hi,

I am new to power bi. Can anyone help me with dynamic axis bar graphs. 

I need to make it dynamic for both axis, X and Y. There are couple of variables on both axis.

Actually, I am looking for pivot table functionality in power BI

Thanks

[amitchandak]

@Minakshi , what do mean by dynamic axis ?

Refer if this can help

https://www.youtube.com/watch?v=6jeSIRpjv0M

[Minakshi]

I want to drop any value on axis and it must change accordingly. 

for example : I want to analyze category, shop, date, subcategory, city(on x-axis) with repespect to 5-6 different type of scores.

[amitchandak · Accepted solution]

@Minakshi , I think that is possible using the bookmarks.

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Or refer to this April 2020 feature

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2020-feature-summary/#_Personalize_v...

[Minakshi]

@amitchandak thanks a lot. it was really great help.

[Pragati11]

HI @Minakshi ,

I am not sure on your requirement as youi haven't mentioned on what basis you want your axis to be dynamic.

Refer following thread for some similar functionalities or define your requirement clearly.

https://community.powerbi.com/t5/Desktop/Dynamic-Changing-X-Axis-on-Chart-based-on-Slicer-Selection/...

Thanks,

Pragati