Forum Discussion
Change the x-axis dynamically
hi
i need to dynamically change the axis where i was using below video but in this video i was need to do the duplicate of table and then do the unpioviting . i am not sure if the values gets changed/added to the main table will the unpivot table creating will get the new column inserted?. Is there any way we an achieve the dynamic axis solution .
https://www.youtube.com/watch?v=n-OWNaCUU0o
else can you propse any other solution please
Hi Anonymous,
I'm afraid there isn't a better solution for now. Because the Axis can't be dynamic for now. There could be a workaround. Please refer to the snapshot below. You can get three levels in one Visual. The Axis will be updated when you go to the next level. They are independent.
Best Regards,
Dale
3 Replies
Hi Anonymous,
Is this the duplicate of this one: https://community.powerbi.com/t5/Desktop/dyamic-axis-implementation-help-needed/m-p/568072#M268139?
Can you share a sample file and the expected results, please?
Best Regards,
Daleyes in the below link i shared the sample file and the scliers of the data needed .can you please check
Hi Anonymous,
I'm afraid there isn't a better solution for now. Because the Axis can't be dynamic for now. There could be a workaround. Please refer to the snapshot below. You can get three levels in one Visual. The Axis will be updated when you go to the next level. They are independent.
Best Regards,
Dale